DBA Data[Home] [Help]

APPS.PAY_NL_NSI_PROCESS dependencies on PAY_PAYROLL_ACTIONS

Line 97: ,pay_payroll_actions ppa

93: ,nl_er_nsi.action_information8
94: ,'OUTPUT_MEDIA_TYPE=P'
95: ,pay_magtape_generic.get_parameter_value('OUTPUT_MEDIA_TYPE')
96: FROM pay_action_information nl_er_nsi
97: ,pay_payroll_actions ppa
98: WHERE nl_er_nsi.action_context_id=ppa.payroll_action_id
99: AND ppa.payroll_action_id=pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
100: AND nl_er_nsi.ACTION_CONTEXT_TYPE='PA'
101: AND nl_er_nsi.ACTION_INFORMATION_CATEGORY='NL NSI EMPLOYER DETAILS'

Line 150: ,pay_payroll_actions ppa

146: ,nl_ee_nsi.action_information23
147: ,'EMPLOYEE_DETAILS=P'
148: ,nl_ee_nsi.action_information24
149: FROM pay_action_information nl_ee_nsi
150: ,pay_payroll_actions ppa
151: ,pay_assignment_actions paa
152: where nl_ee_nsi.ACTION_CONTEXT_ID= paa.assignment_Action_id
153: AND ppa.payroll_Action_id=paa.payroll_Action_id
154: AND ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')