DBA Data[Home] [Help]

APPS.PAY_AE_EFT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 158: FROM pay_assignment_actions pas

154: WHERE ppa.payroll_action_id =
155: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
156: AND EXISTS (
157: SELECT 1
158: FROM pay_assignment_actions pas
159: ,pay_pre_payments ppp
160: WHERE pas.payroll_action_id = ppa.payroll_action_id
161: AND ppp.pre_payment_id = pas.pre_payment_id
162: AND ppp.value <> 0 );

Line 203: ,pay_assignment_actions paa

199: 'LOCAL_NATIONALITY')
200: FROM per_assignments_f paf
201: ,per_people_f pef
202: ,pay_pre_payments ppp
203: ,pay_assignment_actions paa
204: ,pay_payroll_actions ppa
205: WHERE paa.payroll_action_id =
206: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
207: AND paa.pre_payment_id = ppp.pre_payment_id