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_ACTION_INFORMATION

Line 38: pay_action_information pai

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')
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'

Line 67: use_index(pai,pay_action_information_n2)*/

63:
64:
65: cursor csr_p11d_employee is
66: select /*+ ORDERED use_nl(paa,pai)
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')

Line 70: pay_action_information pai

66: select /*+ ORDERED use_nl(paa,pai)
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'

Line 89: use_index(pai_person,pay_action_information_n2)

85: from (
86: -- Benefit from this select may occur only 1 time
87: -- Benefit from this select may occur only 1 time
88: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
89: use_index(pai_person,pay_action_information_n2)
90: use_index(pai,pay_action_information_n2) */
91: decode(pai.action_information_category,
92: 'ASSETS TRANSFERRED', 'A',
93: 'PAYMENTS MADE FOR EMP', 'B',

Line 90: use_index(pai,pay_action_information_n2) */

86: -- Benefit from this select may occur only 1 time
87: -- Benefit from this select may occur only 1 time
88: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
89: use_index(pai_person,pay_action_information_n2)
90: use_index(pai,pay_action_information_n2) */
91: decode(pai.action_information_category,
92: 'ASSETS TRANSFERRED', 'A',
93: 'PAYMENTS MADE FOR EMP', 'B',
94: 'VOUCHERS OR CREDIT CARDS', 'C',

Line 110: pay_action_information pai,

106: 'EXPENSES PAYMENTS', 'N',
107: 'MARORS', 'U') cat
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

Line 111: pay_action_information pai_person

107: 'MARORS', 'U') cat
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

Line 130: use_index(pai_person,pay_action_information_n2)

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.
129: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
130: use_index(pai_person,pay_action_information_n2)
131: use_index(pai,pay_action_information_n2) */
132: decode(pai.action_information_category,
133: 'CAR AND CAR FUEL 2003_04', 'F',
134: 'INT FREE AND LOW INT LOANS', 'H') cat

Line 131: use_index(pai,pay_action_information_n2) */

127: union all -- Benefit from this select may occur more than 1 time or
128: -- it has a special layout/format - ie Expenses Payments.
129: select /*+ ORDERED use_nl(paf,paa,pai,pai_person)
130: use_index(pai_person,pay_action_information_n2)
131: use_index(pai,pay_action_information_n2) */
132: decode(pai.action_information_category,
133: 'CAR AND CAR FUEL 2003_04', 'F',
134: 'INT FREE AND LOW INT LOANS', 'H') cat
135: from per_all_assignments_f paf,

Line 137: pay_action_information pai,

133: 'CAR AND CAR FUEL 2003_04', 'F',
134: 'INT FREE AND LOW INT LOANS', 'H') cat
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

Line 138: pay_action_information pai_person

134: 'INT FREE AND LOW INT LOANS', 'H') cat
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