[Home] [Help]
2195: p.person_id, decode(p.per_information10,'Y','Y',NULL),
2196: ptp.regular_payment_date;
2197: --
2198: -- The 2nd half of union is a copy of csr_all_assignments, but with a join to
2199: -- pay_population_ranges, for performance improvement if the range_person
2200: -- functionality is enabled. Only 1 half will be used as these are made exclusive
2201: -- by the parameter c_range_person_on.
2202: --
2203: -- UNION ALL
2209: p.person_id,
2210: decode(p.per_information10,'Y','Y',NULL) agg_paye_flag,
2211: max(a.effective_end_date) asg_end_date,
2212: ptp.regular_payment_date
2213: FROM pay_population_ranges ppr,
2214: per_all_people_f p,
2215: per_all_assignments_f a,
2216: per_assignment_status_types past,
2217: pay_all_payrolls_f ppf,
3593: from pay_payroll_actions pact,
3594: pay_assignment_actions act,
3595: per_assignments_f paf,
3596: pay_action_interlocks pai,
3597: pay_population_ranges ppr,
3598: ff_archive_items fai
3599: WHERE pact.report_type ='P45'
3600: AND pact.report_qualifier ='GB'
3601: AND pact.report_category ='P45'