APPS.PA_PROGRESS_UTILS dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 925: pa_proj_elem_ver_schedule ppevsh

921: IS
922: SELECT WQ_PLANNED_QUANTITY
923: FROM pa_proj_elements ppe,
924: pa_proj_element_versions ppev,
925: pa_proj_elem_ver_schedule ppevsh
926: WHERE ppe.project_id = ppev.project_id
927: AND ppe.proj_element_id = p_task_id
928: AND ppev.proj_element_id = ppe.proj_element_id
929: AND ppev.element_version_id = ppevsh.element_version_id

Line 1749: FROM pa_proj_elem_ver_schedule

1745:
1746: CURSOR cur_prj_sch
1747: IS
1748: SELECT NVL( wq_planned_quantity, 0 )
1749: FROM pa_proj_elem_ver_schedule
1750: WHERE project_id = p_project_id
1751: AND proj_element_id = p_object_id
1752: AND element_version_id = p_object_version_id;
1753: l_planned_qty NUMBER;

Line 6239: from pa_proj_elem_ver_schedule ppevs

6235:
6236: CURSOR cur_sch_dates
6237: IS
6238: SELECT scheduled_start_date, scheduled_finish_date
6239: from pa_proj_elem_ver_schedule ppevs
6240: where project_id=p_project_id
6241: and element_version_id=p_task_version_id
6242: ;
6243:

Line 6428: from pa_proj_elem_ver_schedule

6424: then
6425: /*select
6426: scheduled_start_date+((scheduled_finish_date-scheduled_start_date)/l_SCH_Performance_Index)
6427: into x_Sch_At_Completion
6428: from pa_proj_elem_ver_schedule
6429: where project_id = p_project_id
6430: and proj_element_id = p_proj_element_id
6431: and element_version_id = p_task_version_id;
6432: */

Line 6617: from pa_proj_elem_ver_schedule ppevs

6613: and ppe.proj_element_id = p_proj_element_id;
6614:
6615: cursor cur_scheduled_dates is
6616: select ppevs.scheduled_start_date, ppevs.scheduled_finish_date
6617: from pa_proj_elem_ver_schedule ppevs
6618: where ppevs.project_id = p_project_id
6619: and ppevs.proj_element_id = p_proj_element_id
6620: and ppevs.element_version_id = (select ppev.element_version_id
6621: from pa_proj_element_versions ppev

Line 7197: from pa_proj_elem_ver_schedule

7193: where element_version_id = p_element_version_id;
7194:
7195: cursor c3(p_project_id NUMBER, p_element_version_id NUMBER) is
7196: select wq_planned_quantity
7197: from pa_proj_elem_ver_schedule
7198: where project_id = p_project_id
7199: and element_version_id = p_element_version_id;
7200:
7201:

Line 10048: from pa_proj_elem_ver_schedule ppevs

10044: is
10045:
10046: cursor cur_lp_sch_start_date(p_str_ver_id NUMBER) is
10047: select scheduled_start_date
10048: from pa_proj_elem_ver_schedule ppevs
10049: where ppevs.project_id = p_project_id
10050: and ppevs.proj_element_id = p_proj_element_id
10051: and ppevs.element_version_id = (select ppev.element_version_id
10052: from pa_proj_element_versions ppev

Line 10060: from pa_proj_elem_ver_schedule ppevs

10056: and ppev.parent_structure_version_id = p_str_ver_id);
10057:
10058: cursor cur_lp_sch_end_date(p_str_ver_id NUMBER) is
10059: select scheduled_finish_date
10060: from pa_proj_elem_ver_schedule ppevs
10061: where ppevs.project_id = p_project_id
10062: and ppevs.proj_element_id = p_proj_element_id
10063: and ppevs.element_version_id = (select ppev.element_version_id
10064: from pa_proj_element_versions ppev

Line 12986: pa_proj_elem_ver_schedule ppevs

12982: from pa_proj_element_versions ppev1,
12983: pa_proj_element_versions ppev2,
12984: pa_object_relationships por,
12985: pa_proj_elements ppe,
12986: pa_proj_elem_ver_schedule ppevs
12987: where ppev1.parent_structure_version_id = p_structure_version_id
12988: and ppev1.proj_element_id=ppe.proj_element_id
12989: and nvl(ppe.link_task_flag,'N') = 'N'
12990: and ppev1.element_version_id=ppevs.element_version_id