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 PER_ALL_ASSIGNMENTS_F

Line 108: from per_all_assignments_f paf,

104: 'OTHER ITEMS', 'M',
105: 'OTHER ITEMS NON 1A', 'M',
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')

Line 114: from per_all_assignments_f paf2

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'))
117: and paf.assignment_id = paa.assignment_id
118: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')

Line 135: from per_all_assignments_f paf,

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

Line 141: from per_all_assignments_f paf2

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'))
144: and paf.assignment_id = paa.assignment_id
145: and paa.payroll_action_id = pay_magtape_generic.get_parameter_value('ARCH_PAYROLL_ACTION_ID')