APPS.PA_TASK_ASSIGNMENT_UTILS dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 869: FROM pa_proj_elem_ver_schedule pevs, pa_proj_element_versions pev,

865: CURSOR C1_Task_Info(p_elem_version_id IN NUMBER) IS
866: SELECT pevs.scheduled_start_date, pevs.scheduled_finish_date,
867: pe.name task_name, pe.element_number task_number,
868: pe.proj_element_id
869: FROM pa_proj_elem_ver_schedule pevs, pa_proj_element_versions pev,
870: pa_proj_elements pe
871: WHERE pev.element_version_id = pevs.element_version_id
872: AND pev.element_version_id = p_elem_version_id
873: AND pev.proj_element_id = pe.proj_element_id;

Line 1431: FROM pa_proj_elem_ver_schedule pevs, pa_proj_element_versions pev,

1427:
1428: CURSOR C1_Task_Dates(p_elem_version_id IN NUMBER) IS
1429: SELECT pevs.scheduled_start_date, pevs.scheduled_finish_date,
1430: pe.name task_name, pe.element_number task_number
1431: FROM pa_proj_elem_ver_schedule pevs, pa_proj_element_versions pev,
1432: pa_proj_elements pe
1433: WHERE pev.element_version_id = pevs.element_version_id
1434: AND pev.element_version_id = p_elem_version_id
1435: AND pev.proj_element_id = pe.proj_element_id;

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

3307: l_num_blocks NUMBER;
3308:
3309: CURSOR c_get_src_sched_dates IS
3310: SELECT pev.element_version_id, pevs.scheduled_start_date, pevs.scheduled_finish_date
3311: FROM pa_copy_asgmts_temp temp, pa_proj_element_versions pev, pa_proj_elem_ver_schedule pevs
3312: WHERE pev.element_version_id = pevs.element_version_id
3313: AND pev.element_version_id = temp.src_elem_ver_id;
3314:
3315: CURSOR c_get_targ_sched_dates IS

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

3313: AND pev.element_version_id = temp.src_elem_ver_id;
3314:
3315: CURSOR c_get_targ_sched_dates IS
3316: SELECT pev.element_version_id, pevs.scheduled_start_date, pevs.scheduled_finish_date
3317: FROM pa_copy_asgmts_temp temp, pa_proj_element_versions pev, pa_proj_elem_ver_schedule pevs
3318: WHERE pev.element_version_id = pevs.element_version_id
3319: AND pev.element_version_id = temp.targ_elem_ver_id;
3320:
3321: CURSOR get_rl_proj_specific_flag(c_resource_list_id NUMBER) IS