APPS.PA_PROJECT_DATES_UTILS dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 181: PA_PROJ_ELEMENT_VERSIONS b

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
185: AND b.element_version_id = a.element_version_id

Line 192: PA_PROJ_ELEMENT_VERSIONS b

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
196: AND b.element_version_id = a.element_version_id

Line 257: PA_PROJ_ELEMENT_VERSIONS b

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
261: AND b.element_version_id = a.element_version_id

Line 268: PA_PROJ_ELEMENT_VERSIONS b

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
272: AND b.element_version_id = a.element_version_id

Line 393: PA_PROJ_ELEMENT_VERSIONS b

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
397: AND b.element_version_id = a.element_version_id;

Line 403: PA_PROJ_ELEMENT_VERSIONS b

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
407: AND b.element_version_id = a.element_version_id;

Line 415: PA_PROJ_ELEMENT_VERSIONS b

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
419: AND b.element_version_id = a.element_version_id

Line 779: PA_PROJ_ELEMENT_VERSIONS b

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
783: AND b.element_version_id = a.element_version_id

Line 818: PA_PROJ_ELEMENT_VERSIONS b

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
822: AND b.element_version_id = a.element_version_id