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

Line 28: pay_magtape_generic.get_parameter_value(

24: CURSOR csr_p11d_header
25: IS
26: SELECT 'TAX_YEAR=P',
27: pay_gb_p11d_magtape.get_parameters(
28: pay_magtape_generic.get_parameter_value(
29: 'ARCH_PAYROLL_ACTION_ID'),
30: 'Rep_Run'),
31: 'SUBMITTER_REF_NO=P',
32: UPPER(

Line 34: pay_magtape_generic.get_parameter_value(

30: 'Rep_Run'),
31: 'SUBMITTER_REF_NO=P',
32: UPPER(
33: TRANSLATE(
34: pay_magtape_generic.get_parameter_value(
35: 'SUBMITTER_REF_NO'),
36: fnd_global.local_chr(10),
37: ' ') ),
38: 'SUBMITTER_NAME=P',

Line 41: pay_magtape_generic.get_parameter_value('SUBMITTER_NAME'),

37: ' ') ),
38: 'SUBMITTER_NAME=P',
39: UPPER(
40: TRANSLATE(
41: pay_magtape_generic.get_parameter_value('SUBMITTER_NAME'),
42: fnd_global.local_chr(10),
43: ' ') ),
44: 'SUB_RET_NO=P',
45: pay_magtape_generic.get_parameter_value('SUB_RET_NO'),

Line 45: pay_magtape_generic.get_parameter_value('SUB_RET_NO'),

41: pay_magtape_generic.get_parameter_value('SUBMITTER_NAME'),
42: fnd_global.local_chr(10),
43: ' ') ),
44: 'SUB_RET_NO=P',
45: pay_magtape_generic.get_parameter_value('SUB_RET_NO'),
46: 'TOT_SUB_RET=P',
47: pay_magtape_generic.get_parameter_value('TOT_SUB_RET'),
48: 'VOL_NO=P', pay_magtape_generic.get_parameter_value('VOL_NO'),
49: 'SENDER_ID=P',pay_gb_p11d_magtape.get_parameters(

Line 47: pay_magtape_generic.get_parameter_value('TOT_SUB_RET'),

43: ' ') ),
44: 'SUB_RET_NO=P',
45: pay_magtape_generic.get_parameter_value('SUB_RET_NO'),
46: 'TOT_SUB_RET=P',
47: pay_magtape_generic.get_parameter_value('TOT_SUB_RET'),
48: 'VOL_NO=P', pay_magtape_generic.get_parameter_value('VOL_NO'),
49: 'SENDER_ID=P',pay_gb_p11d_magtape.get_parameters(
50: pay_magtape_generic.get_parameter_value(
51: 'ARCH_PAYROLL_ACTION_ID'),

Line 48: 'VOL_NO=P', pay_magtape_generic.get_parameter_value('VOL_NO'),

44: 'SUB_RET_NO=P',
45: pay_magtape_generic.get_parameter_value('SUB_RET_NO'),
46: 'TOT_SUB_RET=P',
47: pay_magtape_generic.get_parameter_value('TOT_SUB_RET'),
48: 'VOL_NO=P', pay_magtape_generic.get_parameter_value('VOL_NO'),
49: 'SENDER_ID=P',pay_gb_p11d_magtape.get_parameters(
50: pay_magtape_generic.get_parameter_value(
51: 'ARCH_PAYROLL_ACTION_ID'),
52: 'SENDER_ID'),

Line 50: pay_magtape_generic.get_parameter_value(

46: 'TOT_SUB_RET=P',
47: pay_magtape_generic.get_parameter_value('TOT_SUB_RET'),
48: 'VOL_NO=P', pay_magtape_generic.get_parameter_value('VOL_NO'),
49: 'SENDER_ID=P',pay_gb_p11d_magtape.get_parameters(
50: pay_magtape_generic.get_parameter_value(
51: 'ARCH_PAYROLL_ACTION_ID'),
52: 'SENDER_ID'),
53: 'TEST_SUBMISSION=P',pay_magtape_generic.get_parameter_value('TEST_SUBMISSION'),
54: 'SUBMISSION_TYPE=P',pay_magtape_generic.get_parameter_value('SUBMISSION_TYPE'),

Line 53: 'TEST_SUBMISSION=P',pay_magtape_generic.get_parameter_value('TEST_SUBMISSION'),

49: 'SENDER_ID=P',pay_gb_p11d_magtape.get_parameters(
50: pay_magtape_generic.get_parameter_value(
51: 'ARCH_PAYROLL_ACTION_ID'),
52: 'SENDER_ID'),
53: 'TEST_SUBMISSION=P',pay_magtape_generic.get_parameter_value('TEST_SUBMISSION'),
54: 'SUBMISSION_TYPE=P',pay_magtape_generic.get_parameter_value('SUBMISSION_TYPE'),
55: 'TRANSMISSION_DATE=P',to_char(sysdate,'YYYYMMDDHHMMSS'),
56: 'UNIQUE_REFERENCE=P',pay_gb_p11d_magtape.get_parameters(
57: pay_magtape_generic.get_parameter_value(

Line 54: 'SUBMISSION_TYPE=P',pay_magtape_generic.get_parameter_value('SUBMISSION_TYPE'),

50: pay_magtape_generic.get_parameter_value(
51: 'ARCH_PAYROLL_ACTION_ID'),
52: 'SENDER_ID'),
53: 'TEST_SUBMISSION=P',pay_magtape_generic.get_parameter_value('TEST_SUBMISSION'),
54: 'SUBMISSION_TYPE=P',pay_magtape_generic.get_parameter_value('SUBMISSION_TYPE'),
55: 'TRANSMISSION_DATE=P',to_char(sysdate,'YYYYMMDDHHMMSS'),
56: 'UNIQUE_REFERENCE=P',pay_gb_p11d_magtape.get_parameters(
57: pay_magtape_generic.get_parameter_value(
58: 'ARCH_PAYROLL_ACTION_ID'),

Line 57: pay_magtape_generic.get_parameter_value(

53: 'TEST_SUBMISSION=P',pay_magtape_generic.get_parameter_value('TEST_SUBMISSION'),
54: 'SUBMISSION_TYPE=P',pay_magtape_generic.get_parameter_value('SUBMISSION_TYPE'),
55: 'TRANSMISSION_DATE=P',to_char(sysdate,'YYYYMMDDHHMMSS'),
56: 'UNIQUE_REFERENCE=P',pay_gb_p11d_magtape.get_parameters(
57: pay_magtape_generic.get_parameter_value(
58: 'ARCH_PAYROLL_ACTION_ID'),
59: 'REQUEST_ID')
60: FROM DUAL;
61:

Line 80: pay_magtape_generic.get_parameter_value(

76: 'MESSAGE_DATE=P',
77: to_char(sysdate,'YYYYMMDD'),
78: 'BENEFIT_TAX_YEAR=P',
79: SUBSTR(pay_gb_p11d_magtape.get_parameters(
80: pay_magtape_generic.get_parameter_value(
81: 'ARCH_PAYROLL_ACTION_ID'),
82: 'BENEFIT_END_DATE'),1,4),
83: 'PARTY_NAME=P',
84: pay_gb_p11d_magtape.get_parameters(

Line 85: pay_magtape_generic.get_parameter_value(

81: 'ARCH_PAYROLL_ACTION_ID'),
82: 'BENEFIT_END_DATE'),1,4),
83: 'PARTY_NAME=P',
84: pay_gb_p11d_magtape.get_parameters(
85: pay_magtape_generic.get_parameter_value(
86: 'ARCH_PAYROLL_ACTION_ID'),
87: 'PARTY_NAME')
88: FROM pay_assignment_actions paa, pay_action_information pai
89: WHERE paa.payroll_action_id =

Line 90: pay_magtape_generic.get_parameter_value(

86: 'ARCH_PAYROLL_ACTION_ID'),
87: 'PARTY_NAME')
88: FROM pay_assignment_actions paa, pay_action_information pai
89: WHERE paa.payroll_action_id =
90: pay_magtape_generic.get_parameter_value(
91: 'ARCH_PAYROLL_ACTION_ID')
92: AND pai.action_context_id = paa.assignment_action_id
93: AND pai.action_information_category = 'EMEA PAYROLL INFO';
94:

Line 142: pay_magtape_generic.get_parameter_value(

138: pay_action_information pai_gb,
139: pay_action_information pai_person,
140: hr_lookups hl
141: WHERE paa.payroll_action_id =
142: pay_magtape_generic.get_parameter_value(
143: 'ARCH_PAYROLL_ACTION_ID')
144: AND pai.action_context_id = paa.assignment_action_id
145: AND pai.action_information_category = 'EMEA PAYROLL INFO'
146: AND pai.action_information6 =

Line 147: pay_magtape_generic.get_parameter_value(

143: 'ARCH_PAYROLL_ACTION_ID')
144: AND pai.action_context_id = paa.assignment_action_id
145: AND pai.action_information_category = 'EMEA PAYROLL INFO'
146: AND pai.action_information6 =
147: pay_magtape_generic.get_parameter_value(
148: 'EMPLOYERS_REF_NO')
149: AND pai_person.action_context_id = paa.assignment_action_id
150: AND pai_person.action_information_category =
151: 'ADDRESS DETAILS'

Line 200: pay_magtape_generic.get_parameter_value(

196: pay_action_information pai_person,
197: pay_action_information pai_comp,
198: pay_action_information pai
199: WHERE paa.payroll_action_id =
200: pay_magtape_generic.get_parameter_value(
201: 'ARCH_PAYROLL_ACTION_ID')
202: AND pai_comp.action_context_id = paa.assignment_action_id
203: AND pai_comp.action_information_category = 'EMEA PAYROLL INFO'
204: AND pai_comp.action_context_type = 'AAP'

Line 206: pay_magtape_generic.get_parameter_value('EMPLOYERS_REF_NO')

202: AND pai_comp.action_context_id = paa.assignment_action_id
203: AND pai_comp.action_information_category = 'EMEA PAYROLL INFO'
204: AND pai_comp.action_context_type = 'AAP'
205: AND pai_comp.action_information6 =
206: pay_magtape_generic.get_parameter_value('EMPLOYERS_REF_NO')
207: AND pai_person.action_context_id = paa.assignment_action_id
208: AND pai_person.action_information_category ='ADDRESS DETAILS'
209: AND pai_person.action_context_type = 'AAP'
210: AND pai_person.action_information14 = 'Employee Address'

Line 212: pay_magtape_generic.get_parameter_value('PERSON_ID')

208: AND pai_person.action_information_category ='ADDRESS DETAILS'
209: AND pai_person.action_context_type = 'AAP'
210: AND pai_person.action_information14 = 'Employee Address'
211: AND pai_person.action_information1 =
212: pay_magtape_generic.get_parameter_value('PERSON_ID')
213: AND pai.action_context_id = paa.assignment_action_id
214: AND pai.action_context_type = 'AAP'
215: AND pai.action_information_category NOT IN
216: ('EMPLOYEE DETAILS',

Line 708: pay_magtape_generic.get_parameter_value(

704: pay_action_information pai_comp,
705: pay_action_information pai_resultA,
706: pay_action_information pai
707: WHERE paa.payroll_action_id =
708: pay_magtape_generic.get_parameter_value(
709: 'ARCH_PAYROLL_ACTION_ID')
710: AND pai_comp.action_context_id = paa.assignment_action_id
711: AND pai_comp.action_information_category = 'EMEA PAYROLL INFO'
712: AND pai_comp.action_context_type = 'AAP'

Line 714: pay_magtape_generic.get_parameter_value('EMPLOYERS_REF_NO')

710: AND pai_comp.action_context_id = paa.assignment_action_id
711: AND pai_comp.action_information_category = 'EMEA PAYROLL INFO'
712: AND pai_comp.action_context_type = 'AAP'
713: AND pai_comp.action_information6 =
714: pay_magtape_generic.get_parameter_value('EMPLOYERS_REF_NO')
715:
716: AND pai_resultA.action_context_id = paa.assignment_action_id
717: AND pai_resultA.action_information_category = 'GB P11D ASSIGNMENT RESULTA'
718: AND pai_resultA.action_context_type = 'AAP'

Line 725: pay_magtape_generic.get_parameter_value('PERSON_ID')

721: AND pai_person.action_information_category = 'ADDRESS DETAILS'
722: AND pai_person.action_context_type = 'AAP'
723: AND pai_person.action_information14 = 'Employee Address'
724: AND pai_person.action_information1 =
725: pay_magtape_generic.get_parameter_value('PERSON_ID')
726: AND pai.action_context_id = paa.assignment_action_id
727: AND pai.action_context_type = 'AAP'
728: AND pai.action_information_category LIKE
729: ( pay_magtape_generic.get_parameter_value(

Line 729: ( pay_magtape_generic.get_parameter_value(

725: pay_magtape_generic.get_parameter_value('PERSON_ID')
726: AND pai.action_context_id = paa.assignment_action_id
727: AND pai.action_context_type = 'AAP'
728: AND pai.action_information_category LIKE
729: ( pay_magtape_generic.get_parameter_value(
730: 'ACTION_INFORMATION_CATG')
731: || '%')
732: GROUP BY 'SCHEME_TYPE=P',
733: DECODE(