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.PA_STAFFED_ASSIGNMENT_PVT dependencies on PER_ALL_ASSIGNMENTS_F

Line 686: FROM per_all_assignments_f assn

682: ELSE --IF (nvl(l_future_term_wf_flag,'N') = 'Y')
683:
684: SELECT job_id
685: INTO l_fcst_job_id_tmp
686: FROM per_all_assignments_f assn
687: WHERE assn.person_id = l_person_id_tmp
688: AND l_assignment_rec.start_date BETWEEN assn.effective_start_date
689: AND assn.effective_end_date
690: AND assn.assignment_type in ('C','E')

Line 1626: FROM per_all_assignments_f assn, pa_project_assignments pa

1622: ELSE --IF (nvl(l_future_term_wf_flag,'N') = 'Y')
1623:
1624: SELECT job_id
1625: INTO l_fcst_job_id_tmp
1626: FROM per_all_assignments_f assn, pa_project_assignments pa
1627: WHERE assn.person_id = l_person_id_tmp
1628: AND pa.assignment_id = l_assignment_rec.assignment_id
1629: AND pa.start_date BETWEEN assn.effective_start_date
1630: AND assn.effective_end_date