APPS.PA_TASK_ASSIGNMENT_UTILS dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 803: FROM pa_proj_elem_ver_schedule pevs, pa_proj_element_versions pev,

799: CURSOR C1_Task_Info(p_elem_version_id IN NUMBER) IS
800: SELECT pevs.scheduled_start_date, pevs.scheduled_finish_date,
801: pe.name task_name, pe.element_number task_number,
802: pe.proj_element_id
803: FROM pa_proj_elem_ver_schedule pevs, pa_proj_element_versions pev,
804: pa_proj_elements pe
805: WHERE pev.element_version_id = pevs.element_version_id
806: AND pev.element_version_id = p_elem_version_id
807: AND pev.proj_element_id = pe.proj_element_id;

Line 1323: FROM pa_proj_elem_ver_schedule pevs, pa_proj_element_versions pev,

1319:
1320: CURSOR C1_Task_Dates(p_elem_version_id IN NUMBER) IS
1321: SELECT pevs.scheduled_start_date, pevs.scheduled_finish_date,
1322: pe.name task_name, pe.element_number task_number
1323: FROM pa_proj_elem_ver_schedule pevs, pa_proj_element_versions pev,
1324: pa_proj_elements pe
1325: WHERE pev.element_version_id = pevs.element_version_id
1326: AND pev.element_version_id = p_elem_version_id
1327: AND pev.proj_element_id = pe.proj_element_id;

Line 3196: FROM pa_copy_asgmts_temp temp, pa_proj_element_versions pev, pa_proj_elem_ver_schedule pevs

3192: l_num_blocks NUMBER;
3193:
3194: CURSOR c_get_src_sched_dates IS
3195: SELECT pev.element_version_id, pevs.scheduled_start_date, pevs.scheduled_finish_date
3196: FROM pa_copy_asgmts_temp temp, pa_proj_element_versions pev, pa_proj_elem_ver_schedule pevs
3197: WHERE pev.element_version_id = pevs.element_version_id
3198: AND pev.element_version_id = temp.src_elem_ver_id;
3199:
3200: CURSOR c_get_targ_sched_dates IS

Line 3202: FROM pa_copy_asgmts_temp temp, pa_proj_element_versions pev, pa_proj_elem_ver_schedule pevs

3198: AND pev.element_version_id = temp.src_elem_ver_id;
3199:
3200: CURSOR c_get_targ_sched_dates IS
3201: SELECT pev.element_version_id, pevs.scheduled_start_date, pevs.scheduled_finish_date
3202: FROM pa_copy_asgmts_temp temp, pa_proj_element_versions pev, pa_proj_elem_ver_schedule pevs
3203: WHERE pev.element_version_id = pevs.element_version_id
3204: AND pev.element_version_id = temp.targ_elem_ver_id;
3205:
3206: CURSOR get_rl_proj_specific_flag(c_resource_list_id NUMBER) IS