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.PSP_WF_EFT_PKG dependencies on PER_ASSIGNMENTS_F

Line 41: WHERE ppf.person_id = (select paf.supervisor_id from per_assignments_f paf

37:
38: CURSOR get_supervisor_csr IS
39: SELECT ppf.full_name
40: FROM per_people_f ppf
41: WHERE ppf.person_id = (select paf.supervisor_id from per_assignments_f paf
42: where paf.person_id = l_person_id
43: AND paf.assignment_type ='E' --Added for bug 2624259.
44: AND l_end_perd between paf.effective_start_date and
45: paf.effective_end_date and

Line 220: WHERE ppf.person_id = (select paf.supervisor_id from per_assignments_f paf

216:
217: CURSOR get_supervisor_csr IS
218: SELECT ppf.full_name, ppf.person_id
219: FROM per_people_f ppf
220: WHERE ppf.person_id = (select paf.supervisor_id from per_assignments_f paf
221: where paf.person_id = l_person_id
222: AND paf.assignment_type ='E' --Added for bug 2624259.
223: AND l_end_perd between paf.effective_start_date and
224: paf.effective_end_date and