[Home] [Help]
2326: order by ptp.regular_payment_date desc, a.assignment_id, a.assignment_number, a.period_of_service_id,
2327: p.person_id, decode(p.per_information10,'Y','Y',NULL);
2328: --
2329: -- The 2nd half of union is a copy of csr_all_assignments, but with a join to
2330: -- pay_population_ranges, for performance improvement if the range_person
2331: -- functionality is enabled. Only 1 half will be used as these are made exclusive
2332: -- by the parameter c_range_person_on.
2333: --
2334: -- UNION ALL
2340: p.person_id,
2341: decode(p.per_information10,'Y','Y',NULL) agg_paye_flag,
2342: max(a.effective_end_date) asg_end_date,
2343: ptp.regular_payment_date
2344: FROM pay_population_ranges ppr,
2345: per_all_people_f p,
2346: per_all_assignments_f a,
2347: per_assignment_status_types past,
2348: pay_all_payrolls_f ppf,
4367: --
4368: -- Used Not Exists instead of using Outer Join : Bug :7442831
4369: SELECT /*+ordered
4370: index(pact PAY_PAYROLL_ACTIONS_N52)
4371: index(ppr PAY_POPULATION_RANGES_N4)
4372: index(act PAY_ASSIGNMENT_ACTIONS_N51)
4373: index(fai FF_ARCHIVE_ITEMS_N50)*/
4374: DISTINCT
4375: act.assignment_action_id archive_action,
4374: DISTINCT
4375: act.assignment_action_id archive_action,
4376: act.assignment_id
4377: from pay_payroll_actions pact,
4378: pay_population_ranges ppr,
4379: per_assignments_f paf,
4380: pay_assignment_actions act,
4381: ff_archive_items fai
4382: WHERE pact.report_type ='P45'