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_AU_TFN_MAGTAPE_FLAGS dependencies on PER_ASSIGNMENTS_F

Line 138: FROM per_assignments_f a

134: OR nvl(pps.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY')) BETWEEN c_report_end_date - 13 AND c_report_end_date
135: )
136: ) /* Bug#5864230 */
137: AND paa.effective_start_date = (SELECT max(effective_start_date)
138: FROM per_assignments_f a
139: WHERE a.assignment_id = paa.assignment_id)
140: and pap.effective_start_date=(select max(effective_start_date)
141: from per_people_f p
142: where p.person_id=pap.person_id) --Bug 4925794

Line 243: FROM per_assignments_f paa,

239: c_legal_employer_id in hr_soft_coding_keyflex.segment1%TYPE,
240: c_report_end_date in date) IS
241: SELECT pee.assignment_id
242: ,pev.screen_entry_value tfn_for_super_flag
243: FROM per_assignments_f paa,
244: hr_soft_coding_keyflex hsc,
245: pay_element_entry_values_f pev,
246: pay_input_values_f piv,
247: pay_element_types_f pet,

Line 268: FROM per_assignments_f a

264: WHERE pee1.element_entry_id = pee.element_entry_id
265: AND pee1.effective_start_date <= c_report_end_date
266: )
267: AND paa.effective_start_date = (SELECT max(effective_start_date)
268: FROM per_assignments_f a
269: WHERE a.assignment_id = paa.assignment_id
270: )
271: AND pev.effective_start_date = (SELECT max(pev1.effective_start_date)
272: FROM pay_element_entry_values_f pev1