APPS.PA_PROGRESS_PVT dependencies on PA_PROJ_ELEM_VER_SCHEDULE

Line 323: FROM pa_proj_elem_ver_schedule

319:
320: CURSOR cur_sch_id( c_object_version_id NUMBER )
321: IS
322: SELECT pev_schedule_id, record_version_number
323: FROM pa_proj_elem_ver_schedule
324: WHERE project_id = p_project_id
325: AND element_version_id = c_object_version_id;
326:
327:

Line 331: FROM pa_proj_elem_ver_schedule

327:
328: CURSOR c_get_dates (c_project_id NUMBER, c_element_version_id NUMBER)
329: IS
330: SELECT scheduled_start_date, scheduled_finish_date
331: FROM pa_proj_elem_ver_schedule
332: WHERE PROJECT_ID = c_project_id
333: AND element_version_id = c_element_version_id;
334:
335: CURSOR c_get_dlv_status(c_task_id NUMBER) IS

Line 3509: UPDATE pa_proj_elem_ver_schedule

3505:
3506: END IF;
3507: -- 5119716 End
3508:
3509: UPDATE pa_proj_elem_ver_schedule
3510: SET ACTUAL_START_DATE = l_actual_start_date
3511: , ACTUAL_FINISH_DATE = l_actual_finish_date
3512: , ESTIMATED_START_DATE = l_rollup_table1(i).start_date2
3513: , ESTIMATED_FINISH_DATE = l_rollup_table1(i).finish_date2

Line 6656: FROM pa_proj_elem_ver_schedule

6652: -- Bug 3956299 Begin
6653: CURSOR c_get_dates (c_project_id NUMBER, c_element_version_id NUMBER)
6654: IS
6655: SELECT scheduled_start_date, scheduled_finish_date
6656: FROM pa_proj_elem_ver_schedule
6657: WHERE PROJECT_ID = c_project_id
6658: AND element_version_id = c_element_version_id;
6659:
6660: l_tsk_scheduled_start_date Date;