eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_NSI_PROCESS dependencies on PAY_MAGTAPE_GENERIC

Line 95: ,pay_magtape_generic.get_parameter_value('OUTPUT_MEDIA_TYPE')

91: ,nl_er_nsi.action_information7
92: ,'EMPLOYER_REGISTRATION_NUMBER=P'
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')

Line 99: AND ppa.payroll_action_id=pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

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'
102: AND nl_er_nsi.effective_date between ppa.start_date
103: and last_day(to_date('01'||pay_magtape_generic.get_parameter_value('NSI_MONTH'),'DDMMYYYY'));

Line 103: and last_day(to_date('01'||pay_magtape_generic.get_parameter_value('NSI_MONTH'),'DDMMYYYY'));

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'
102: AND nl_er_nsi.effective_date between ppa.start_date
103: and last_day(to_date('01'||pay_magtape_generic.get_parameter_value('NSI_MONTH'),'DDMMYYYY'));
104:
105:
106:
107: /********************************************************

Line 154: AND ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

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')
155: AND nl_ee_nsi.action_context_type='AAP'
156: AND nl_ee_nsi.action_information_category = 'NL NSI EMPLOYEE DETAILS'
157: AND nl_ee_nsi.effective_date BETWEEN ppa.start_date
158: AND last_day(to_date('01'||pay_magtape_generic.get_parameter_value('NSI_MONTH'),'DDMMYYYY'))

Line 158: AND last_day(to_date('01'||pay_magtape_generic.get_parameter_value('NSI_MONTH'),'DDMMYYYY'))

154: AND ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
155: AND nl_ee_nsi.action_context_type='AAP'
156: AND nl_ee_nsi.action_information_category = 'NL NSI EMPLOYEE DETAILS'
157: AND nl_ee_nsi.effective_date BETWEEN ppa.start_date
158: AND last_day(to_date('01'||pay_magtape_generic.get_parameter_value('NSI_MONTH'),'DDMMYYYY'))
159: order by nl_ee_nsi.action_information_id; --Bug No : 3612117
160: END PAY_NL_NSI_PROCESS;