APPS.PA_PROJECT_DATES_UTILS dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 220: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

216: IS
217: CURSOR get_task_sch_dates_csr
218: IS
219: SELECT a.scheduled_start_date, a.last_update_date
220: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
221: PA_PROJ_ELEMENT_VERSIONS b
222: WHERE b.parent_structure_version_id = p_parent_structure_version_id
223: AND b.project_id = p_project_id
224: AND b.proj_element_id = p_proj_element_id

Line 231: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

227:
228: CURSOR get_task_act_dates_csr
229: IS
230: SELECT a.actual_start_date, a.last_update_date
231: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
232: PA_PROJ_ELEMENT_VERSIONS b
233: WHERE b.parent_structure_version_id = p_parent_structure_version_id
234: AND b.project_id = p_project_id
235: AND b.proj_element_id = p_proj_element_id

Line 296: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

292: IS
293: CURSOR get_task_sch_dates_csr
294: IS
295: SELECT a.scheduled_finish_date, a.last_update_date
296: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
297: PA_PROJ_ELEMENT_VERSIONS b
298: WHERE b.parent_structure_version_id = p_parent_structure_version_id
299: AND b.project_id = p_project_id
300: AND b.proj_element_id = p_proj_element_id

Line 307: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

303:
304: CURSOR get_task_act_dates_csr
305: IS
306: SELECT a.actual_finish_date, a.last_update_date
307: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
308: PA_PROJ_ELEMENT_VERSIONS b
309: WHERE b.parent_structure_version_id = p_parent_structure_version_id
310: AND b.project_id = p_project_id
311: AND b.proj_element_id = p_proj_element_id

Line 432: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

428: /* Commented for bug 5258713
429: CURSOR get_task_sch_dates_csr
430: IS
431: SELECT a.scheduled_start_date, a.scheduled_finish_date
432: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
433: PA_PROJ_ELEMENT_VERSIONS b
434: WHERE b.parent_structure_version_id = p_parent_structure_version_id
435: AND b.project_id = p_project_id
436: AND b.proj_element_id = p_proj_element_id

Line 442: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

438:
439: CURSOR get_task_act_dates_csr
440: IS
441: SELECT a.actual_start_date, a.actual_finish_date
442: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
443: PA_PROJ_ELEMENT_VERSIONS b
444: WHERE b.parent_structure_version_id = p_parent_structure_version_id
445: AND b.project_id = p_project_id
446: AND b.proj_element_id = p_proj_element_id

Line 454: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

450: /*Added for bug 5258713 - Merged the two cursors*/
451: CURSOR get_task_dates_csr
452: IS
453: SELECT a.actual_start_date, a.actual_finish_date,a.scheduled_start_date, a.scheduled_finish_date
454: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
455: PA_PROJ_ELEMENT_VERSIONS b
456: WHERE b.parent_structure_version_id = p_parent_structure_version_id
457: AND b.project_id = p_project_id
458: AND b.proj_element_id = p_proj_element_id

Line 681: FROM PA_PROJ_ELEM_VER_SCHEDULE

677: SELECT scheduled_start_date,
678: scheduled_finish_date,
679: last_update_date,
680: pa_proj_elements_utils.convert_hr_to_days(duration)
681: FROM PA_PROJ_ELEM_VER_SCHEDULE
682: WHERE element_version_id = p_structure_version_id;
683:
684: l_scheduled_start_date DATE;
685: l_scheduled_finish_date DATE;

Line 818: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

814:
815: CURSOR cur_chk_act_fin_dt
816: IS
817: SELECT 'x'
818: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
819: PA_PROJ_ELEMENT_VERSIONS b
820: WHERE b.parent_structure_version_id = p_parent_structure_version_id
821: AND b.project_id = p_project_id
822: AND b.proj_element_id = a.proj_element_id

Line 857: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

853:
854: CURSOR cur_chk_act_fin_dt
855: IS
856: SELECT 'x'
857: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
858: PA_PROJ_ELEMENT_VERSIONS b
859: WHERE b.parent_structure_version_id = p_parent_structure_version_id
860: AND b.project_id = p_project_id
861: AND b.proj_element_id = a.proj_element_id