DBA Data[Home] [Help]

APPS.PAY_KW_EFT dependencies on PAY_PRE_PAYMENTS

Line 138: ,pay_pre_payments ppp

134: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
135: AND EXISTS (
136: SELECT 1
137: FROM pay_assignment_actions pas
138: ,pay_pre_payments ppp
139: WHERE pas.payroll_action_id = ppa.payroll_action_id
140: AND ppp.pre_payment_id = pas.pre_payment_id
141: AND ppp.value > 0 );
142: /********************************************************

Line 175: ,pay_pre_payments ppp

171: ,pay_kw_general.get_parameter(ppa.legislative_parameters,
172: 'LOCAL_NATIONALITY')
173: FROM per_assignments_f paf
174: ,per_people_f pef
175: ,pay_pre_payments ppp
176: ,pay_assignment_actions paa
177: ,pay_payroll_actions ppa
178: WHERE paa.payroll_action_id =
179: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')