1954: pet.processing_priority
1955: from pay_action_interlocks pai,
1956: pay_assignment_actions paa,
1957: pay_payroll_actions ppa,
1958: pay_all_payrolls_f ppf,
1959: pay_run_results prr,
1960: pay_element_types_f pet,
1961: pay_element_classifications pec,
1962: pay_element_types_f_tl petl
2943: pay_element_classifications pec,
2944: pay_assignment_actions paa,
2945: pay_payroll_actions ppa,
2946: pay_element_types_f_tl petl,
2947: pay_all_payrolls_f ppf */ -- Bug 3370112
2948: where ppa.action_type in ('R', 'Q', 'B')
2949: and ppa.effective_date > cp_last_xfr_eff_date
2950: and ppa.effective_date <= cp_pymt_eff_date
2951: and ppa.payroll_id = ppf.payroll_id