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

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

5:
6: Cursor Csr_NL_Annual_SI_Header IS
7:
8: SELECT
9: 'TAX_YEAR=P',pay_magtape_generic.get_parameter_value('TAX_YEAR'),
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')

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

7:
8: SELECT
9: 'TAX_YEAR=P',pay_magtape_generic.get_parameter_value('TAX_YEAR'),
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

Line 12: 'ORG_HEIRARCHY_ID=P',pay_magtape_generic.get_parameter_value('ORG_HEIRARCHY'),

8: SELECT
9: 'TAX_YEAR=P',pay_magtape_generic.get_parameter_value('TAX_YEAR'),
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')

Line 13: 'SI_PROVIDER_ID=P',pay_magtape_generic.get_parameter_value('SI_PROVIDER_ID')

9: 'TAX_YEAR=P',pay_magtape_generic.get_parameter_value('TAX_YEAR'),
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

Line 16: =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_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
19: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
20:

Line 19: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));

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
19: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
20:
21:
22: Cursor Csr_NL_Annual_SI_Body IS
23: SELECT

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

36: pay_action_interlocks arc_lck,
37: pay_action_information ee_asi,
38: per_all_people_f pap
39: WHERE pay_act.payroll_action_id
40: =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
41: AND pay_act.assignment_action_id = arc_lck.locking_action_id
42: AND arc_lck.locking_action_id = ee_asi.action_context_id
43: AND ee_asi.action_context_type='AAP'
44: AND ee_asi.action_information_category = 'NL ASI EMPLOYEE DETAILS'