DBA Data[Home] [Help]

APPS.PAY_SA_EFT dependencies on PAY_MAGTAPE_GENERIC

Line 141: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

137: ,'SUM1=P'
138: ,pay_sa_general.get_sum * 100
139: FROM pay_payroll_actions ppa
140: WHERE ppa.payroll_action_id =
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

Line 189: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

185: ,pay_pre_payments ppp
186: ,pay_assignment_actions paa
187: ,pay_payroll_actions ppa
188: WHERE paa.payroll_action_id =
189: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
190: AND paa.pre_payment_id = ppp.pre_payment_id
191: AND paa.payroll_action_id = ppa.payroll_action_id
192: AND paa.assignment_id = paf.assignment_id
193: AND paf.person_id = pef.person_id