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_TAXOFFICE_FILE dependencies on PAY_MAGTAPE_GENERIC

Line 108: 'TAX_YEAR=P',pay_magtape_generic.get_parameter_value('REPORT_YEAR'),

104: */
105:
106: Cursor Csr_NL_TaxOff_Header IS
107: SELECT
108: 'TAX_YEAR=P',pay_magtape_generic.get_parameter_value('REPORT_YEAR'),
109: 'BUSINESS_GROUP_ID=P',ppa.business_group_id,
110: 'EMPLOYER_ID=P',pay_magtape_generic.get_parameter_value('EMPLOYER_ID'),
111: 'ORG_STRUCT_ID=P',pay_magtape_generic.get_parameter_value('ORG_HIERARCHY'),
112: 'MEDIUM_CODE=P',pay_magtape_generic.get_parameter_value('MEDIUM_CODE'),

Line 110: 'EMPLOYER_ID=P',pay_magtape_generic.get_parameter_value('EMPLOYER_ID'),

106: Cursor Csr_NL_TaxOff_Header IS
107: SELECT
108: 'TAX_YEAR=P',pay_magtape_generic.get_parameter_value('REPORT_YEAR'),
109: 'BUSINESS_GROUP_ID=P',ppa.business_group_id,
110: 'EMPLOYER_ID=P',pay_magtape_generic.get_parameter_value('EMPLOYER_ID'),
111: 'ORG_STRUCT_ID=P',pay_magtape_generic.get_parameter_value('ORG_HIERARCHY'),
112: 'MEDIUM_CODE=P',pay_magtape_generic.get_parameter_value('MEDIUM_CODE'),
113: 'DENSITY=P',pay_magtape_generic.get_parameter_value('DENSITY_CODE')
114: FROM pay_payroll_actions ppa

Line 111: 'ORG_STRUCT_ID=P',pay_magtape_generic.get_parameter_value('ORG_HIERARCHY'),

107: SELECT
108: 'TAX_YEAR=P',pay_magtape_generic.get_parameter_value('REPORT_YEAR'),
109: 'BUSINESS_GROUP_ID=P',ppa.business_group_id,
110: 'EMPLOYER_ID=P',pay_magtape_generic.get_parameter_value('EMPLOYER_ID'),
111: 'ORG_STRUCT_ID=P',pay_magtape_generic.get_parameter_value('ORG_HIERARCHY'),
112: 'MEDIUM_CODE=P',pay_magtape_generic.get_parameter_value('MEDIUM_CODE'),
113: 'DENSITY=P',pay_magtape_generic.get_parameter_value('DENSITY_CODE')
114: FROM pay_payroll_actions ppa
115: WHERE ppa.payroll_action_id

Line 112: 'MEDIUM_CODE=P',pay_magtape_generic.get_parameter_value('MEDIUM_CODE'),

108: 'TAX_YEAR=P',pay_magtape_generic.get_parameter_value('REPORT_YEAR'),
109: 'BUSINESS_GROUP_ID=P',ppa.business_group_id,
110: 'EMPLOYER_ID=P',pay_magtape_generic.get_parameter_value('EMPLOYER_ID'),
111: 'ORG_STRUCT_ID=P',pay_magtape_generic.get_parameter_value('ORG_HIERARCHY'),
112: 'MEDIUM_CODE=P',pay_magtape_generic.get_parameter_value('MEDIUM_CODE'),
113: 'DENSITY=P',pay_magtape_generic.get_parameter_value('DENSITY_CODE')
114: FROM pay_payroll_actions ppa
115: WHERE ppa.payroll_action_id
116: =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');

Line 113: 'DENSITY=P',pay_magtape_generic.get_parameter_value('DENSITY_CODE')

109: 'BUSINESS_GROUP_ID=P',ppa.business_group_id,
110: 'EMPLOYER_ID=P',pay_magtape_generic.get_parameter_value('EMPLOYER_ID'),
111: 'ORG_STRUCT_ID=P',pay_magtape_generic.get_parameter_value('ORG_HIERARCHY'),
112: 'MEDIUM_CODE=P',pay_magtape_generic.get_parameter_value('MEDIUM_CODE'),
113: 'DENSITY=P',pay_magtape_generic.get_parameter_value('DENSITY_CODE')
114: FROM pay_payroll_actions ppa
115: WHERE ppa.payroll_action_id
116: =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
117:

Line 116: =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');

112: 'MEDIUM_CODE=P',pay_magtape_generic.get_parameter_value('MEDIUM_CODE'),
113: 'DENSITY=P',pay_magtape_generic.get_parameter_value('DENSITY_CODE')
114: FROM pay_payroll_actions ppa
115: WHERE ppa.payroll_action_id
116: =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
117:
118:
119:
120: /********************************************************

Line 153: =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

149: pay_action_interlocks arc_lck,
150: pay_action_information ee_ats,
151: per_all_people_f pap
152: WHERE pay_act.payroll_action_id
153: =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
154: AND pay_act.assignment_action_id = arc_lck.locking_action_id
155: AND arc_lck.locked_action_id = ee_ats.action_context_id
156: AND ee_ats.action_context_type='AAP'
157: AND ee_ats.action_information_category = 'NL ATS EMPLOYEE DETAILS'