[Home] [Help]
60:
61: FROM pay_payroll_actions ppa,
62: pay_assignment_actions paa,
63: per_all_assignments_f paf,
64: pay_pre_payments ppp
65:
66: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
67: and ppp.pre_payment_id = paa.pre_payment_id
68: and ppp.value > 0
98:
99: FROM pay_assignment_actions paa,
100: per_all_assignments_f paf,
101: pay_payroll_actions ppa,
102: pay_pre_payments ppp,
103: pay_org_payment_methods_f pop,
104: per_all_people_f pef,
105: pay_external_accounts pea,
106: hr_soft_coding_keyflex hsk,
151: FROM pay_assignment_actions act,
152: per_all_assignments_f asg,
153: pay_payroll_actions pa2,
154: pay_payroll_actions pa1,
155: pay_pre_payments ppp,
156: pay_org_payment_methods_f OPM,
157: per_all_people_f pap,
158: hr_soft_coding_keyflex hsk,
159: pay_payment_types ppt
230: FROM pay_assignment_actions act,
231: per_all_assignments_f asg,
232: pay_payroll_actions pa2,
233: pay_payroll_actions pa1,
234: pay_pre_payments ppp,
235: pay_org_payment_methods_f OPM,
236: per_all_people_f pap,
237: hr_soft_coding_keyflex hsk,
238: pay_payment_types ppt
253: AND ppt.payment_type_id= opm.payment_type_id
254: AND ( ppt.category not in ('MT') and exists ( select '1' FROM
255: pay_org_payment_methods_f opm1
256: ,pay_payment_types ppt1
257: ,pay_pre_payments ppp1
258: WHERE ppp1.assignment_action_id = act.assignment_action_id--2023513440
259: AND ppp1.org_payment_method_id = opm1.org_payment_method_id
260: AND ppt1.payment_type_id= opm1.payment_type_id
261: AND ppt1.category in ('MT')))
304:
305: FROM pay_assignment_actions paa,
306: per_all_assignments_f paf,
307: pay_payroll_actions ppa,
308: pay_pre_payments ppp,
309: pay_org_payment_methods_f pop,
310: per_all_people_f pef,
311: per_addresses pad,
312: pay_external_accounts pea,