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_CREATE_EFF_REPORTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 1276: per_all_assignments_f paf

1272:
1273: cursor get_skipped_asg is
1274: select distinct pspt.skip_reason, pspt.person_id, paf.assignment_number
1275: from psp_selected_persons_t pspt,
1276: per_all_assignments_f paf
1277: where pspt.request_id = p_request_id
1278: and pspt.person_id between p_start_person and p_end_person
1279: and pspt.assignment_id = paf.assignment_id
1280: and pspt.skip_reason is not null

Line 1282: from per_all_assignments_f paf2

1278: and pspt.person_id between p_start_person and p_end_person
1279: and pspt.assignment_id = paf.assignment_id
1280: and pspt.skip_reason is not null
1281: and paf.effective_start_date = (select max(paf2.effective_start_date)
1282: from per_all_assignments_f paf2
1283: where paf2.assignment_id = paf.assignment_id);
1284:
1285: skipped_asg_rec get_skipped_asg%rowtype;
1286: