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

Line 13: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'Rep_Run'),

9:
10: -- CURSOR --
11: cursor csr_p11d_header is
12: select 'TAX_YEAR=P',pay_gb_p11d_magtape.get_parameters(
13: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'Rep_Run'),
14: 'TEST_SUBMISSION=P',pay_magtape_generic.get_parameter_value('TEST_SUBMISSION'),
15: 'TRANSMISSION_DATE=P',to_char(sysdate,'YYYYMMDDHHMMSS'),
16: 'PAYROLL_ACTION_ID=P',pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')
17: from dual;

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

10: -- CURSOR --
11: cursor csr_p11d_header is
12: select 'TAX_YEAR=P',pay_gb_p11d_magtape.get_parameters(
13: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'Rep_Run'),
14: 'TEST_SUBMISSION=P',pay_magtape_generic.get_parameter_value('TEST_SUBMISSION'),
15: 'TRANSMISSION_DATE=P',to_char(sysdate,'YYYYMMDDHHMMSS'),
16: 'PAYROLL_ACTION_ID=P',pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')
17: from dual;
18:

Line 16: 'PAYROLL_ACTION_ID=P',pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')

12: select 'TAX_YEAR=P',pay_gb_p11d_magtape.get_parameters(
13: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'Rep_Run'),
14: 'TEST_SUBMISSION=P',pay_magtape_generic.get_parameter_value('TEST_SUBMISSION'),
15: 'TRANSMISSION_DATE=P',to_char(sysdate,'YYYYMMDDHHMMSS'),
16: 'PAYROLL_ACTION_ID=P',pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')
17: from dual;
18:
19: cursor csr_p11d_employer is
20: select 'TAX_OFFICE_NAME=P', NVL(UPPER(action_information4), ' '),

Line 27: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),

23: 'EMPLOYERS_NAME=P', NVL(UPPER(action_information7), ' '),
24: 'EMPLOYERS_ADDRESS=P', NVL(UPPER(action_information8), ' '),
25: 'MESSAGE_DATE=P', to_char(sysdate,'YYYYMMDD'),
26: 'PARTY_NAME=P', pay_gb_p11d_magtape.get_parameters(
27: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),
28: 'PARTY_NAME',action_information6),
29: 'SENDER_ID=P', pay_gb_p11d_magtape.get_parameters(
30: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SENDER_ID',
31: action_information6),

Line 30: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SENDER_ID',

26: 'PARTY_NAME=P', pay_gb_p11d_magtape.get_parameters(
27: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),
28: 'PARTY_NAME',action_information6),
29: 'SENDER_ID=P', pay_gb_p11d_magtape.get_parameters(
30: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SENDER_ID',
31: action_information6),
32: 'UNIQUE_REFERENCE=P', to_number(pay_gb_p11d_magtape.get_parameters(
33: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'REQUEST_ID')),
34: 'SUBMITTER_REF_NO=P', pay_gb_p11d_magtape.get_parameters(

Line 33: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'REQUEST_ID')),

29: 'SENDER_ID=P', pay_gb_p11d_magtape.get_parameters(
30: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SENDER_ID',
31: action_information6),
32: 'UNIQUE_REFERENCE=P', to_number(pay_gb_p11d_magtape.get_parameters(
33: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'REQUEST_ID')),
34: 'SUBMITTER_REF_NO=P', pay_gb_p11d_magtape.get_parameters(
35: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SUBMITTER_REF_NO',
36: action_information6)
37: from pay_assignment_actions paa,

Line 35: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SUBMITTER_REF_NO',

31: action_information6),
32: 'UNIQUE_REFERENCE=P', to_number(pay_gb_p11d_magtape.get_parameters(
33: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'REQUEST_ID')),
34: 'SUBMITTER_REF_NO=P', pay_gb_p11d_magtape.get_parameters(
35: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SUBMITTER_REF_NO',
36: action_information6)
37: from pay_assignment_actions paa,
38: pay_action_information pai
39: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')

Line 39: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')

35: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SUBMITTER_REF_NO',
36: action_information6)
37: from pay_assignment_actions paa,
38: pay_action_information pai
39: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')
40: and pai.action_context_id = paa.assignment_action_id
41: and pai.action_information_category = 'EMEA PAYROLL INFO'
42: and pai.action_context_type = 'AAP'
43: and (pay_magtape_generic.get_parameter_value('TAX_REFERENCE') is null

Line 43: and (pay_magtape_generic.get_parameter_value('TAX_REFERENCE') is null

39: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')
40: and pai.action_context_id = paa.assignment_action_id
41: and pai.action_information_category = 'EMEA PAYROLL INFO'
42: and pai.action_context_type = 'AAP'
43: and (pay_magtape_generic.get_parameter_value('TAX_REFERENCE') is null
44: or
45: upper(pai.action_information6) = upper(pay_magtape_generic.get_parameter_value('TAX_REFERENCE')))
46: group by 'TAX_OFFICE_NAME=P', NVL(UPPER(action_information4), ' '),
47: 'TAX_OFFICE_PHONE_NO=P', NVL(UPPER(action_information5), ' '),

Line 45: upper(pai.action_information6) = upper(pay_magtape_generic.get_parameter_value('TAX_REFERENCE')))

41: and pai.action_information_category = 'EMEA PAYROLL INFO'
42: and pai.action_context_type = 'AAP'
43: and (pay_magtape_generic.get_parameter_value('TAX_REFERENCE') is null
44: or
45: upper(pai.action_information6) = upper(pay_magtape_generic.get_parameter_value('TAX_REFERENCE')))
46: group by 'TAX_OFFICE_NAME=P', NVL(UPPER(action_information4), ' '),
47: 'TAX_OFFICE_PHONE_NO=P', NVL(UPPER(action_information5), ' '),
48: 'EMPLOYERS_REF_NO=P', NVL(UPPER(action_information6), ' '),
49: 'EMPLOYERS_NAME=P', NVL(UPPER(action_information7), ' '),

Line 53: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),

49: 'EMPLOYERS_NAME=P', NVL(UPPER(action_information7), ' '),
50: 'EMPLOYERS_ADDRESS=P', NVL(UPPER(action_information8), ' '),
51: 'MESSAGE_DATE=P', to_char(sysdate,'YYYYMMDD'),
52: 'PARTY_NAME=P', pay_gb_p11d_magtape.get_parameters(
53: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),
54: 'PARTY_NAME',action_information6),
55: 'SENDER_ID=P', pay_gb_p11d_magtape.get_parameters(
56: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SENDER_ID',
57: action_information6),

Line 56: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SENDER_ID',

52: 'PARTY_NAME=P', pay_gb_p11d_magtape.get_parameters(
53: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),
54: 'PARTY_NAME',action_information6),
55: 'SENDER_ID=P', pay_gb_p11d_magtape.get_parameters(
56: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SENDER_ID',
57: action_information6),
58: 'UNIQUE_REFERENCE=P', to_number(pay_gb_p11d_magtape.get_parameters(
59: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'REQUEST_ID')),
60: 'SUBMITTER_REF_NO=P', pay_gb_p11d_magtape.get_parameters(

Line 59: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'REQUEST_ID')),

55: 'SENDER_ID=P', pay_gb_p11d_magtape.get_parameters(
56: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SENDER_ID',
57: action_information6),
58: 'UNIQUE_REFERENCE=P', to_number(pay_gb_p11d_magtape.get_parameters(
59: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'REQUEST_ID')),
60: 'SUBMITTER_REF_NO=P', pay_gb_p11d_magtape.get_parameters(
61: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SUBMITTER_REF_NO',
62: action_information6);
63:

Line 61: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SUBMITTER_REF_NO',

57: action_information6),
58: 'UNIQUE_REFERENCE=P', to_number(pay_gb_p11d_magtape.get_parameters(
59: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'REQUEST_ID')),
60: 'SUBMITTER_REF_NO=P', pay_gb_p11d_magtape.get_parameters(
61: pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID'),'SUBMITTER_REF_NO',
62: action_information6);
63:
64:
65: cursor csr_p11d_employee is

Line 71: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')

67: use_index(pai,pay_action_information_n2)*/
68: 'PERSON_ID=P',pai.action_information10
69: from pay_assignment_actions paa,
70: pay_action_information pai
71: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')
72: and pai.action_context_id = paa.assignment_action_id
73: and pai.action_information_category = 'GB EMPLOYEE DETAILS'
74: and pai.action_context_type = 'AAP'
75: and upper(pai.action_information13) = upper(pay_magtape_generic.get_parameter_value('EMPLOYERS_REF_NO'))

Line 75: and upper(pai.action_information13) = upper(pay_magtape_generic.get_parameter_value('EMPLOYERS_REF_NO'))

71: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')
72: and pai.action_context_id = paa.assignment_action_id
73: and pai.action_information_category = 'GB EMPLOYEE DETAILS'
74: and pai.action_context_type = 'AAP'
75: and upper(pai.action_information13) = upper(pay_magtape_generic.get_parameter_value('EMPLOYERS_REF_NO'))
76: and pay_gb_p11d_edi_control.fetch_total_benefit(paa.assignment_action_id,
77: paa.payroll_action_id,
78: pai.action_information13) > 0
79: group by 'PERSON_ID=P',pai.action_information10;

Line 112: where paf.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID')

108: from per_all_assignments_f paf,
109: pay_assignment_actions paa,
110: pay_action_information pai,
111: pay_action_information pai_person
112: where paf.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID')
113: and paf.effective_end_date = (select max(paf2.effective_end_date)
114: from per_all_assignments_f paf2
115: where paf2.assignment_id = paf.assignment_id
116: and paf2.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID'))

Line 116: and paf2.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID'))

112: where paf.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID')
113: and paf.effective_end_date = (select max(paf2.effective_end_date)
114: from per_all_assignments_f paf2
115: where paf2.assignment_id = paf.assignment_id
116: and paf2.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID'))
117: and paf.assignment_id = paa.assignment_id
118: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')
119: and pai.action_context_id = paa.assignment_action_id
120: and pai.action_context_type = 'AAP'

Line 118: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')

114: from per_all_assignments_f paf2
115: where paf2.assignment_id = paf.assignment_id
116: and paf2.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID'))
117: and paf.assignment_id = paa.assignment_id
118: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')
119: and pai.action_context_id = paa.assignment_action_id
120: and pai.action_context_type = 'AAP'
121: and pai.action_information_category = pai.action_information_category
122: and pai_person.action_context_id = paa.assignment_action_id

Line 124: and upper(pai_person.action_information13) = upper(pay_magtape_generic.get_parameter_value('EMPLOYERS_REF_NO'))

120: and pai.action_context_type = 'AAP'
121: and pai.action_information_category = pai.action_information_category
122: and pai_person.action_context_id = paa.assignment_action_id
123: and pai_person.action_information_category = 'GB EMPLOYEE DETAILS'
124: and upper(pai_person.action_information13) = upper(pay_magtape_generic.get_parameter_value('EMPLOYERS_REF_NO'))
125: and pai_person.action_context_type = 'AAP')
126: group by cat -- pai.action_information_category
127: union all -- Benefit from this select may occur more than 1 time or
128: -- it has a special layout/format - ie Expenses Payments.

Line 139: where paf.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID')

135: from per_all_assignments_f paf,
136: pay_assignment_actions paa,
137: pay_action_information pai,
138: pay_action_information pai_person
139: where paf.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID')
140: and paf.effective_end_date = (select max(paf2.effective_end_date)
141: from per_all_assignments_f paf2
142: where paf2.assignment_id = paf.assignment_id
143: and paf2.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID'))

Line 143: and paf2.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID'))

139: where paf.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID')
140: and paf.effective_end_date = (select max(paf2.effective_end_date)
141: from per_all_assignments_f paf2
142: where paf2.assignment_id = paf.assignment_id
143: and paf2.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID'))
144: and paf.assignment_id = paa.assignment_id
145: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')
146: and pai.action_context_id = paa.assignment_action_id
147: and pai.action_context_type = 'AAP'

Line 145: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')

141: from per_all_assignments_f paf2
142: where paf2.assignment_id = paf.assignment_id
143: and paf2.person_id = pay_magtape_generic.get_parameter_value('PERSON_ID'))
144: and paf.assignment_id = paa.assignment_id
145: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')
146: and pai.action_context_id = paa.assignment_action_id
147: and pai.action_context_type = 'AAP'
148: and pai.action_information_category = pai.action_information_category
149: and pai_person.action_context_id = paa.assignment_action_id

Line 151: and upper(pai_person.action_information13) = upper(pay_magtape_generic.get_parameter_value('EMPLOYERS_REF_NO'))

147: and pai.action_context_type = 'AAP'
148: and pai.action_information_category = pai.action_information_category
149: and pai_person.action_context_id = paa.assignment_action_id
150: and pai_person.action_information_category = 'GB EMPLOYEE DETAILS'
151: and upper(pai_person.action_information13) = upper(pay_magtape_generic.get_parameter_value('EMPLOYERS_REF_NO'))
152: and pai_person.action_context_type = 'AAP')
153: where cat in ('A',
154: 'B',
155: 'C',