APPS.PAY_NO_PAYPROC dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 103: pay_org_payment_methods_f pop,

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,
107: pay_payment_types ppt

Line 156: pay_org_payment_methods_f OPM,

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
160:

Line 235: pay_org_payment_methods_f OPM,

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
239: WHERE pa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 255: pay_org_payment_methods_f opm1

251: AND ppp.assignment_action_id = act.assignment_action_id
252: AND ppp.org_payment_method_id = opm.org_payment_method_id
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

Line 309: pay_org_payment_methods_f pop,

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,
313: hr_soft_coding_keyflex hsk,