APPS.PA_PROGRESS_UTILS dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 921: pa_proj_elem_ver_schedule ppevsh

917: IS
918: SELECT WQ_PLANNED_QUANTITY
919: FROM pa_proj_elements ppe,
920: pa_proj_element_versions ppev,
921: pa_proj_elem_ver_schedule ppevsh
922: WHERE ppe.project_id = ppev.project_id
923: AND ppe.proj_element_id = p_task_id
924: AND ppev.proj_element_id = ppe.proj_element_id
925: AND ppev.element_version_id = ppevsh.element_version_id

Line 1727: FROM pa_proj_elem_ver_schedule

1723:
1724: CURSOR cur_prj_sch
1725: IS
1726: SELECT NVL( wq_planned_quantity, 0 )
1727: FROM pa_proj_elem_ver_schedule
1728: WHERE project_id = p_project_id
1729: AND proj_element_id = p_object_id
1730: AND element_version_id = p_object_version_id;
1731: l_planned_qty NUMBER;

Line 6204: from pa_proj_elem_ver_schedule ppevs

6200:
6201: CURSOR cur_sch_dates
6202: IS
6203: SELECT scheduled_start_date, scheduled_finish_date
6204: from pa_proj_elem_ver_schedule ppevs
6205: where project_id=p_project_id
6206: and element_version_id=p_task_version_id
6207: ;
6208:

Line 6388: from pa_proj_elem_ver_schedule

6384: then
6385: /*select
6386: scheduled_start_date+((scheduled_finish_date-scheduled_start_date)/l_SCH_Performance_Index)
6387: into x_Sch_At_Completion
6388: from pa_proj_elem_ver_schedule
6389: where project_id = p_project_id
6390: and proj_element_id = p_proj_element_id
6391: and element_version_id = p_task_version_id;
6392: */

Line 6577: from pa_proj_elem_ver_schedule ppevs

6573: and ppe.proj_element_id = p_proj_element_id;
6574:
6575: cursor cur_scheduled_dates is
6576: select ppevs.scheduled_start_date, ppevs.scheduled_finish_date
6577: from pa_proj_elem_ver_schedule ppevs
6578: where ppevs.project_id = p_project_id
6579: and ppevs.proj_element_id = p_proj_element_id
6580: and ppevs.element_version_id = (select ppev.element_version_id
6581: from pa_proj_element_versions ppev

Line 7157: from pa_proj_elem_ver_schedule

7153: where element_version_id = p_element_version_id;
7154:
7155: cursor c3(p_project_id NUMBER, p_element_version_id NUMBER) is
7156: select wq_planned_quantity
7157: from pa_proj_elem_ver_schedule
7158: where project_id = p_project_id
7159: and element_version_id = p_element_version_id;
7160:
7161:

Line 9974: from pa_proj_elem_ver_schedule ppevs

9970: is
9971:
9972: cursor cur_lp_sch_start_date(p_str_ver_id NUMBER) is
9973: select scheduled_start_date
9974: from pa_proj_elem_ver_schedule ppevs
9975: where ppevs.project_id = p_project_id
9976: and ppevs.proj_element_id = p_proj_element_id
9977: and ppevs.element_version_id = (select ppev.element_version_id
9978: from pa_proj_element_versions ppev

Line 9986: from pa_proj_elem_ver_schedule ppevs

9982: and ppev.parent_structure_version_id = p_str_ver_id);
9983:
9984: cursor cur_lp_sch_end_date(p_str_ver_id NUMBER) is
9985: select scheduled_finish_date
9986: from pa_proj_elem_ver_schedule ppevs
9987: where ppevs.project_id = p_project_id
9988: and ppevs.proj_element_id = p_proj_element_id
9989: and ppevs.element_version_id = (select ppev.element_version_id
9990: from pa_proj_element_versions ppev

Line 12891: pa_proj_elem_ver_schedule ppevs

12887: from pa_proj_element_versions ppev1,
12888: pa_proj_element_versions ppev2,
12889: pa_object_relationships por,
12890: pa_proj_elements ppe,
12891: pa_proj_elem_ver_schedule ppevs
12892: where ppev1.parent_structure_version_id = p_structure_version_id
12893: and ppev1.proj_element_id=ppe.proj_element_id
12894: and nvl(ppe.link_task_flag,'N') = 'N'
12895: and ppev1.element_version_id=ppevs.element_version_id