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_ACTION_INFORMATION

Line 65: use_index(pai,pay_action_information_n2) */

61:
62: CURSOR csr_p11d_employer
63: IS
64: SELECT /*+ ordered use_nl(paa,pai)
65: use_index(pai,pay_action_information_n2) */
66: DISTINCT 'TAX_OFFICE_NAME=P',
67: NVL(UPPER(action_information4), ' '),
68: 'TAX_OFFICE_PHONE_NO=P',
69: NVL(UPPER(action_information5), ' '),

Line 88: FROM pay_assignment_actions paa, pay_action_information pai

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 =
90: pay_magtape_generic.get_parameter_value(
91: 'ARCH_PAYROLL_ACTION_ID')
92: AND pai.action_context_id = paa.assignment_action_id

Line 102: use_index(pai,pay_action_information_n2)

98: use_nl(paa, pai)
99: use_nl(paa, pai_emp)
100: use_nl(paa, pai_gb)
101: use_nl(paa, pai_person)
102: use_index(pai,pay_action_information_n2)
103: use_index(pai_emp,pay_action_information_n2)
104: use_index(pai_gb,pay_action_information_n2)
105: use_index(pai_person,pay_action_information_n2)*/
106: DISTINCT 'LAST_NAME=P',

Line 103: use_index(pai_emp,pay_action_information_n2)

99: use_nl(paa, pai_emp)
100: use_nl(paa, pai_gb)
101: use_nl(paa, pai_person)
102: use_index(pai,pay_action_information_n2)
103: use_index(pai_emp,pay_action_information_n2)
104: use_index(pai_gb,pay_action_information_n2)
105: use_index(pai_person,pay_action_information_n2)*/
106: DISTINCT 'LAST_NAME=P',
107: NVL(

Line 104: use_index(pai_gb,pay_action_information_n2)

100: use_nl(paa, pai_gb)
101: use_nl(paa, pai_person)
102: use_index(pai,pay_action_information_n2)
103: use_index(pai_emp,pay_action_information_n2)
104: use_index(pai_gb,pay_action_information_n2)
105: use_index(pai_person,pay_action_information_n2)*/
106: DISTINCT 'LAST_NAME=P',
107: NVL(
108: SUBSTR(UPPER(pai_gb.action_information8), 1, 36),

Line 105: use_index(pai_person,pay_action_information_n2)*/

101: use_nl(paa, pai_person)
102: use_index(pai,pay_action_information_n2)
103: use_index(pai_emp,pay_action_information_n2)
104: use_index(pai_gb,pay_action_information_n2)
105: use_index(pai_person,pay_action_information_n2)*/
106: DISTINCT 'LAST_NAME=P',
107: NVL(
108: SUBSTR(UPPER(pai_gb.action_information8), 1, 36),
109: ' '),

Line 136: pay_action_information pai,

132: NVL(pai_person.action_information8, ' '),
133: 'ADDRESS_LINE_5=P',
134: NVL(hl.meaning, ' ')
135: FROM pay_assignment_actions paa,
136: pay_action_information pai,
137: pay_action_information pai_emp,
138: pay_action_information pai_gb,
139: pay_action_information pai_person,
140: hr_lookups hl

Line 137: pay_action_information pai_emp,

133: 'ADDRESS_LINE_5=P',
134: NVL(hl.meaning, ' ')
135: FROM pay_assignment_actions paa,
136: pay_action_information pai,
137: pay_action_information pai_emp,
138: pay_action_information pai_gb,
139: pay_action_information pai_person,
140: hr_lookups hl
141: WHERE paa.payroll_action_id =

Line 138: pay_action_information pai_gb,

134: NVL(hl.meaning, ' ')
135: FROM pay_assignment_actions paa,
136: pay_action_information pai,
137: pay_action_information pai_emp,
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(

Line 139: pay_action_information pai_person,

135: FROM pay_assignment_actions paa,
136: pay_action_information pai,
137: pay_action_information pai_emp,
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')

Line 168: use_index(pai,pay_action_information_n2)

164: SELECT /*+ ordered
165: use_nl(paa,pai)
166: use_nl(paa,pai_comp)
167: use_nl(paa,pai_person)
168: use_index(pai,pay_action_information_n2)
169: use_index(pai_comp,pay_action_information_n2)
170: use_index(pai_person,pay_action_information_n2)*/
171: 'ACTION_INFORMATION_CATG=P',
172: pai.action_information_category,

Line 169: use_index(pai_comp,pay_action_information_n2)

165: use_nl(paa,pai)
166: use_nl(paa,pai_comp)
167: use_nl(paa,pai_person)
168: use_index(pai,pay_action_information_n2)
169: use_index(pai_comp,pay_action_information_n2)
170: use_index(pai_person,pay_action_information_n2)*/
171: 'ACTION_INFORMATION_CATG=P',
172: pai.action_information_category,
173: DECODE(

Line 170: use_index(pai_person,pay_action_information_n2)*/

166: use_nl(paa,pai_comp)
167: use_nl(paa,pai_person)
168: use_index(pai,pay_action_information_n2)
169: use_index(pai_comp,pay_action_information_n2)
170: use_index(pai_person,pay_action_information_n2)*/
171: 'ACTION_INFORMATION_CATG=P',
172: pai.action_information_category,
173: DECODE(
174: pai.action_information_category,

Line 196: pay_action_information pai_person,

192: 'CAERS', 'U',
193: 'OTHER ITEMS NON 1A', 'N',
194: 'CAR AND CAR FUEL 2003_04', 'F') cat_order
195: FROM pay_assignment_actions paa,
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(

Line 197: pay_action_information pai_comp,

193: 'OTHER ITEMS NON 1A', 'N',
194: 'CAR AND CAR FUEL 2003_04', 'F') cat_order
195: FROM pay_assignment_actions paa,
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')

Line 198: pay_action_information pai

194: 'CAR AND CAR FUEL 2003_04', 'F') cat_order
195: FROM pay_assignment_actions paa,
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

Line 225: from pay_action_information pai1

221: 'GB P11D ASSIGNMENT RESULTB',
222: 'GB P11D ASSIGNMENT RESULTC')
223: AND (( pai.action_information_category = 'OTHER ITEMS NON 1A'
224: AND not exists (select 1
225: from pay_action_information pai1
226: where pai1.action_context_id = paa.assignment_action_id
227: and pai1.action_context_type = 'AAP'
228: and pai1.action_information_category = 'OTHER ITEMS')
229: )

Line 242: use_index(pai,pay_action_information_n2)

238: SELECT /*+ ordered
239: use_nl(paa,pai)
240: use_nl(paa,pai_comp)
241: use_nl(paa,pai_person)
242: use_index(pai,pay_action_information_n2)
243: use_index(pai_comp,pay_action_information_n2)
244: use_index(pai_person,pay_action_information_n2)*/
245: 'SCHEME_TYPE=P',
246: DECODE(

Line 243: use_index(pai_comp,pay_action_information_n2)

239: use_nl(paa,pai)
240: use_nl(paa,pai_comp)
241: use_nl(paa,pai_person)
242: use_index(pai,pay_action_information_n2)
243: use_index(pai_comp,pay_action_information_n2)
244: use_index(pai_person,pay_action_information_n2)*/
245: 'SCHEME_TYPE=P',
246: DECODE(
247: pai.action_information_category,

Line 244: use_index(pai_person,pay_action_information_n2)*/

240: use_nl(paa,pai_comp)
241: use_nl(paa,pai_person)
242: use_index(pai,pay_action_information_n2)
243: use_index(pai_comp,pay_action_information_n2)
244: use_index(pai_person,pay_action_information_n2)*/
245: 'SCHEME_TYPE=P',
246: DECODE(
247: pai.action_information_category,
248: 'TAXABLE EXPENSE PAYMENTS', pai.action_information6,

Line 703: pay_action_information pai_person,

699: pai.action_information_category,
700: 'TAXABLE EXPENSE PAYMENTS', pai.action_information9,
701: '0') )
702: FROM pay_assignment_actions paa,
703: pay_action_information pai_person,
704: pay_action_information pai_comp,
705: pay_action_information pai_resultA,
706: pay_action_information pai
707: WHERE paa.payroll_action_id =

Line 704: pay_action_information pai_comp,

700: 'TAXABLE EXPENSE PAYMENTS', pai.action_information9,
701: '0') )
702: FROM pay_assignment_actions paa,
703: pay_action_information pai_person,
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(

Line 705: pay_action_information pai_resultA,

701: '0') )
702: FROM pay_assignment_actions paa,
703: pay_action_information pai_person,
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')

Line 706: pay_action_information pai

702: FROM pay_assignment_actions paa,
703: pay_action_information pai_person,
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