APPS.PA_PROJECT_DATES_UTILS dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 180: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

176: IS
177: CURSOR get_task_sch_dates_csr
178: IS
179: SELECT a.scheduled_start_date, a.last_update_date
180: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
181: PA_PROJ_ELEMENT_VERSIONS b
182: WHERE b.parent_structure_version_id = p_parent_structure_version_id
183: AND b.project_id = p_project_id
184: AND b.proj_element_id = p_proj_element_id

Line 191: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

187:
188: CURSOR get_task_act_dates_csr
189: IS
190: SELECT a.actual_start_date, a.last_update_date
191: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
192: PA_PROJ_ELEMENT_VERSIONS b
193: WHERE b.parent_structure_version_id = p_parent_structure_version_id
194: AND b.project_id = p_project_id
195: AND b.proj_element_id = p_proj_element_id

Line 256: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

252: IS
253: CURSOR get_task_sch_dates_csr
254: IS
255: SELECT a.scheduled_finish_date, a.last_update_date
256: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
257: PA_PROJ_ELEMENT_VERSIONS b
258: WHERE b.parent_structure_version_id = p_parent_structure_version_id
259: AND b.project_id = p_project_id
260: AND b.proj_element_id = p_proj_element_id

Line 267: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

263:
264: CURSOR get_task_act_dates_csr
265: IS
266: SELECT a.actual_finish_date, a.last_update_date
267: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
268: PA_PROJ_ELEMENT_VERSIONS b
269: WHERE b.parent_structure_version_id = p_parent_structure_version_id
270: AND b.project_id = p_project_id
271: AND b.proj_element_id = p_proj_element_id

Line 392: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

388: /* Commented for bug 5258713
389: CURSOR get_task_sch_dates_csr
390: IS
391: SELECT a.scheduled_start_date, a.scheduled_finish_date
392: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
393: PA_PROJ_ELEMENT_VERSIONS b
394: WHERE b.parent_structure_version_id = p_parent_structure_version_id
395: AND b.project_id = p_project_id
396: AND b.proj_element_id = p_proj_element_id

Line 402: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

398:
399: CURSOR get_task_act_dates_csr
400: IS
401: SELECT a.actual_start_date, a.actual_finish_date
402: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
403: PA_PROJ_ELEMENT_VERSIONS b
404: WHERE b.parent_structure_version_id = p_parent_structure_version_id
405: AND b.project_id = p_project_id
406: AND b.proj_element_id = p_proj_element_id

Line 414: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

410: /*Added for bug 5258713 - Merged the two cursors*/
411: CURSOR get_task_dates_csr
412: IS
413: SELECT a.actual_start_date, a.actual_finish_date,a.scheduled_start_date, a.scheduled_finish_date
414: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
415: PA_PROJ_ELEMENT_VERSIONS b
416: WHERE b.parent_structure_version_id = p_parent_structure_version_id
417: AND b.project_id = p_project_id
418: AND b.proj_element_id = p_proj_element_id

Line 641: FROM PA_PROJ_ELEM_VER_SCHEDULE

637: SELECT scheduled_start_date,
638: scheduled_finish_date,
639: last_update_date,
640: pa_proj_elements_utils.convert_hr_to_days(duration)
641: FROM PA_PROJ_ELEM_VER_SCHEDULE
642: WHERE element_version_id = p_structure_version_id;
643:
644: l_scheduled_start_date DATE;
645: l_scheduled_finish_date DATE;

Line 778: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

774:
775: CURSOR cur_chk_act_fin_dt
776: IS
777: SELECT 'x'
778: FROM PA_PROJ_ELEM_VER_SCHEDULE a,
779: PA_PROJ_ELEMENT_VERSIONS b
780: WHERE b.parent_structure_version_id = p_parent_structure_version_id
781: AND b.project_id = p_project_id
782: AND b.proj_element_id = a.proj_element_id

Line 817: FROM PA_PROJ_ELEM_VER_SCHEDULE a,

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