APPS.PA_PROGRESS_PUB dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 277: FROM pa_proj_elem_ver_schedule

273: IS
274: SELECT
275: scheduled_start_date
276: , scheduled_finish_date
277: FROM pa_proj_elem_ver_schedule
278: WHERE project_id = p_project_id
279: AND element_version_id = p_object_version_id
280: AND proj_element_id = p_object_id;
281:

Line 328: FROM pa_proj_elem_ver_schedule

324: IS
325: SELECT
326: pev_schedule_id
327: , record_version_number
328: FROM pa_proj_elem_ver_schedule
329: WHERE project_id = p_project_id
330: AND element_version_id = c_object_version_id;
331:
332: l_pev_schedule_id NUMBER;

Line 5551: -- 3922325 : Added pa_proj_elem_ver_schedule join to get scheduled_start_date

5547: l_msg_index_out NUMBER;
5548: l_error_msg_code VARCHAR2(250);
5549: l_structure_version_id NUMBER;
5550:
5551: -- 3922325 : Added pa_proj_elem_ver_schedule join to get scheduled_start_date
5552: -- 4743866, modified the cursor below as join with ppc is not required in most of the cases
5553: CURSOR cur_tasks
5554: IS
5555: SELECT pobj.object_id_to1, ppev1.proj_element_id,

Line 5569: pa_proj_elem_ver_schedule sch

5565: SELECT to_number(null) object_id_from1, p_object_version_id object_id_to1
5566: FROM DUAL
5567: ) pobj,
5568: pa_proj_element_versions ppev1,
5569: pa_proj_elem_ver_schedule sch
5570: WHERE pobj.object_id_to1 = ppev1.element_version_id
5571: AND ppev1.element_version_id = sch.element_version_id;
5572:
5573: ---4743866, added following cursor on ppc to get required info

Line 7346: from pa_proj_elem_ver_schedule

7342: );
7343: cursor l_scheduled_dates_cur(p_project_id NUMBER, p_object_id NUMBER, p_object_version_id NUMBER) is
7344: select scheduled_start_date
7345: ,scheduled_finish_date
7346: from pa_proj_elem_ver_schedule
7347: where project_id = p_project_id
7348: and proj_element_id = p_object_id
7349: and element_version_id = p_object_version_id;
7350:

Line 11774: from pa_proj_elem_ver_schedule

11770: ORDER BY published_date desc;
11771:
11772: CURSOR c_get_sch_dates(c_project_id NUMBER, c_object_version_id NUMBER) IS
11773: select scheduled_start_date, scheduled_finish_date
11774: from pa_proj_elem_ver_schedule
11775: where project_id = c_project_id
11776: and element_version_id = c_object_version_id ;
11777:
11778: CURSOR c_ptav_cur(c_project_id NUMBER, c_object_id NUMBER, c_task_id NUMBER, c_task_version_id NUMBER, c_structure_version_id NUMBER, c_ta_display_flag VARCHAR2, c_cbs_element_id NUMBER) IS

Line 14216: pa_proj_elem_ver_schedule ppevs,

14212: ppevs.scheduled_start_date,
14213: ppevs.scheduled_finish_date
14214: from pa_proj_elements ppe,
14215: pa_proj_element_versions ppev,
14216: pa_proj_elem_ver_schedule ppevs,
14217: pa_task_types ptt
14218: where ppev.proj_element_id = l_obj
14219: and ppev.parent_structure_version_id = l_latest_wp_struct_ver_id
14220: and ppev.proj_element_id = ppe.proj_element_id

Line 22432: from pa_proj_elem_ver_schedule

22428: and trunc(ppr.as_of_date) <= trunc(c_as_of_date);
22429:
22430: CURSOR c_get_sch_dates(c_project_id NUMBER, c_task_id NUMBER, c_task_ver_id NUMBER) IS
22431: select pev_schedule_id, actual_start_date, actual_finish_date, estimated_start_date, estimated_finish_date
22432: from pa_proj_elem_ver_schedule
22433: where project_id = c_project_id
22434: and proj_element_id = c_task_id
22435: and element_version_id = c_task_ver_id
22436: ;

Line 22514: UPDATE pa_proj_elem_ver_schedule

22510: IF l_max_est_fin_date IS NOT NULL AND l_est_fin_date IS NOT NULL THEN
22511: l_estimated_finish_date_rollup := l_est_fin_date - l_max_est_fin_date;
22512: END IF;
22513:
22514: UPDATE pa_proj_elem_ver_schedule
22515: SET actual_start_date_rollup= l_actual_start_date_rollup
22516: , actual_finish_date_rollup = l_actual_finish_date_rollup
22517: , estimated_start_date_rollup = l_estimated_start_date_rollup
22518: , estimated_finish_date_rollup = l_estimated_finish_date_rollup