Analytics Software

Hello All,

I am devloping a disc report.
I need information abt empoyee objectives along with plans also info about payrolls,people gruops..etc...So Used the follwoing query can any kindly let me know whether the below query is correct or not..(It is retreving few records)


SELECT papf.employee_number, papf.full_name,
papf1.employee_number supervisor_id, papf1.full_name supervisor_name,
hou.NAME organization_name, pj.NAME job_name, po.NAME objective_name,
po.comments, po.success_criteria, ppf.payroll_name, ppf.period_type,
ppg.group_name, po.measure_name, po.measure_comments, ppmp.plan_name
FROM apps.per_all_people_f papf,
apps.per_assignments_f paf,
apps.per_jobs pj,
apps.per_objectives po,
apps.per_all_people_f papf1,
apps.pay_payrolls_f ppf,
apps.pay_people_groups ppg,
apps.hr_organization_units hou,
apps.per_appraisals pa,
apps.per_perf_mgmt_plans ppmp
WHERE papf.person_id = paf.person_id
AND paf.job_id = pj.job_id
AND papf.person_id = po.owning_person_id
AND papf1.person_id = paf.supervisor_id
AND paf.payroll_id = ppf.payroll_id
AND paf.people_group_id = ppg.people_group_id
AND hou.organization_id = paf.organization_id
AND po.appraisal_id = pa.appraisal_id
AND pa.plan_id = ppmp.plan_id
AND TRUNC (SYSDATE) BETWEEN TRUNC (papf.effective_start_date)
AND TRUNC (papf.effective_end_date)
AND TRUNC (SYSDATE) BETWEEN TRUNC (paf.effective_start_date)
AND TRUNC (paf.effective_end_date)
AND TRUNC (SYSDATE) BETWEEN TRUNC (ppf.effective_start_date)
AND TRUNC (ppf.effective_end_date)
AND TRUNC (SYSDATE) BETWEEN TRUNC (papf1.effective_start_date)
AND TRUNC (papf1.effective_end_date)