DBA Data[Home] [Help]

APPS.PAY_SA_EFT dependencies on PAY_PRE_PAYMENTS

Line 145: ,pay_pre_payments ppp

141: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
142: AND EXISTS (
143: SELECT 1
144: FROM pay_assignment_actions pas
145: ,pay_pre_payments ppp
146: WHERE pas.payroll_action_id = ppa.payroll_action_id
147: AND ppp.pre_payment_id = pas.pre_payment_id
148: AND ppp.value > 0 );
149: /********************************************************

Line 184: ,pay_pre_payments ppp

180: ,pay_sa_general.get_parameter(ppa.legislative_parameters,
181: 'LOCAL_NATIONALITY')
182: FROM per_assignments_f paf
183: ,per_people_f pef
184: ,pay_pre_payments ppp
185: ,pay_assignment_actions paa
186: ,pay_payroll_actions ppa
187: WHERE paa.payroll_action_id =
188: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')