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 1278: per_all_assignments_f paf

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

Line 1284: from per_all_assignments_f paf2

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