DBA Data[Home] [Help]

APPS.PAY_AE_EFT dependencies on PAY_PAYROLL_ACTIONS

Line 153: FROM pay_payroll_actions ppa

149: ,'SUMD=P'
150: ,nvl(to_char(pay_ae_general.get_debit_sum * 100),'0')
151: ,'TAPE_TYPE=P'
152: ,nvl(pay_ae_general.get_parameter(ppa.legislative_parameters,'TAPE_TYPE'),' ')
153: FROM pay_payroll_actions ppa
154: WHERE ppa.payroll_action_id =
155: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
156: AND EXISTS (
157: SELECT 1

Line 204: ,pay_payroll_actions ppa

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
208: AND paa.payroll_action_id = ppa.payroll_action_id