DBA Data[Home] [Help]

APPS.PAY_NO_PAYPROC dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 66: pay_org_payment_methods_f pop,

62: FROM pay_payroll_actions ppa,
63: pay_assignment_actions paa,
64: per_all_assignments_f paf,
65: pay_pre_payments ppp,
66: pay_org_payment_methods_f pop,
67: pay_payment_types ppt,
68: pay_org_pay_method_usages_f ppu
69:
70: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 115: PAY_ORG_PAYMENT_METHODS_F pop,

111: FROM pay_assignment_actions paa,
112: per_all_assignments_f paf,
113: pay_payroll_actions ppa,
114: pay_pre_payments ppp,
115: PAY_ORG_PAYMENT_METHODS_F pop,
116: per_all_people_f pef,
117: pay_external_accounts pea,
118: -- hr_soft_coding_keyflex hsk,
119: pay_payment_types ppt,

Line 174: pay_org_payment_methods_f OPM,

170: per_all_assignments_f asg,
171: pay_payroll_actions pa2,
172: pay_payroll_actions pa1,
173: pay_pre_payments ppp,
174: pay_org_payment_methods_f OPM,
175: per_all_people_f pap,
176: -- hr_soft_coding_keyflex hsk,
177: pay_payment_types ppt
178:

Line 255: pay_org_payment_methods_f OPM,

251: per_all_assignments_f asg,
252: pay_payroll_actions pa2,
253: pay_payroll_actions pa1,
254: pay_pre_payments ppp,
255: pay_org_payment_methods_f OPM,
256: per_all_people_f pap,
257: -- hr_soft_coding_keyflex hsk,
258: pay_payment_types ppt
259: WHERE pa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 277: pay_org_payment_methods_f opm1

273: AND ppp.org_payment_method_id = opm.org_payment_method_id
274: AND opm.pmeth_information_category <> 'NO_THIRD_PARTY_PAYMENT'
275: AND ppt.payment_type_id= opm.payment_type_id
276: AND ( ppt.category not in ('MT') and exists ( select '1' FROM
277: pay_org_payment_methods_f opm1
278: ,pay_payment_types ppt1
279: ,pay_pre_payments ppp1
280: WHERE ppp1.assignment_action_id = act.assignment_action_id--2023513440
281: AND ppp1.org_payment_method_id = opm1.org_payment_method_id

Line 331: pay_org_payment_methods_f pop,

327: FROM pay_assignment_actions paa,
328: per_all_assignments_f paf,
329: pay_payroll_actions ppa,
330: pay_pre_payments ppp,
331: pay_org_payment_methods_f pop,
332: per_all_people_f pef,
333: -- per_addresses pad,
334: pay_external_accounts pea,
335: -- hr_soft_coding_keyflex hsk,