22: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
23: AND EXISTS (
24: SELECT 1
25: FROM pay_assignment_actions pas
26: ,pay_pre_payments ppp
27: WHERE pas.payroll_action_id = ppa.payroll_action_id
28: AND ppp.pre_payment_id = pas.pre_payment_id );
29:
30:
54: from
55: pay_payroll_actions ppa
56: ,pay_assignment_actions paa
57: ,per_all_assignments_f paf
58: ,pay_pre_payments ppp
59: ,pay_personal_payment_methods_f pppm
60: ,per_all_people_f pef
61: ,pay_external_accounts pea
62: ,hr_soft_coding_keyflex hsck