DBA Data[Home] [Help]

APPS.PA_STAFFED_ASSIGNMENT_PVT dependencies on PER_ALL_ASSIGNMENTS_F

Line 717: FROM per_all_assignments_f assn

713: ELSE --IF (nvl(l_future_term_wf_flag,'N') = 'Y')
714:
715: SELECT job_id
716: INTO l_fcst_job_id_tmp
717: FROM per_all_assignments_f assn
718: WHERE assn.person_id = l_person_id_tmp
719: AND l_assignment_rec.start_date BETWEEN assn.effective_start_date
720: AND assn.effective_end_date
721: AND assn.assignment_type in ('C','E')

Line 1657: FROM per_all_assignments_f assn, pa_project_assignments pa

1653: ELSE --IF (nvl(l_future_term_wf_flag,'N') = 'Y')
1654:
1655: SELECT job_id
1656: INTO l_fcst_job_id_tmp
1657: FROM per_all_assignments_f assn, pa_project_assignments pa
1658: WHERE assn.person_id = l_person_id_tmp
1659: AND pa.assignment_id = l_assignment_rec.assignment_id
1660: AND pa.start_date BETWEEN assn.effective_start_date
1661: AND assn.effective_end_date