DBA Data[Home] [Help]

APPS.PAY_NL_ANNUAL_SI_FILE dependencies on PAY_PAYROLL_ACTIONS

Line 14: FROM pay_payroll_actions ppa

10: 'BUSINESS_GROUP_ID=P',ppa.business_group_id,
11: 'EMPLOYER_ID=P',pay_magtape_generic.get_parameter_value('EMPLOYER_ID'),
12: 'ORG_HEIRARCHY_ID=P',pay_magtape_generic.get_parameter_value('ORG_HEIRARCHY'),
13: 'SI_PROVIDER_ID=P',pay_magtape_generic.get_parameter_value('SI_PROVIDER_ID')
14: FROM pay_payroll_actions ppa
15: WHERE ppa.payroll_action_id
16: =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
17: AND EXISTS
18: (select * from pay_assignment_actions paa