APPS.PA_PROJECT_DATES_PUB dependencies on PA_PROGRESS_ROLLUP

Line 82: FROM PA_PROGRESS_ROLLUP

78:
79: CURSOR get_task_est_dates_csr(c_task_id NUMBER)
80: IS
81: SELECT estimated_start_date, estimated_finish_date
82: FROM PA_PROGRESS_ROLLUP
83: WHERE project_id = p_project_id
84: AND object_id = c_task_id
85: AND object_type = 'PA_TASKS'
86: AND as_of_date = (

Line 87: select max(as_of_date) from pa_progress_rollup

83: WHERE project_id = p_project_id
84: AND object_id = c_task_id
85: AND object_type = 'PA_TASKS'
86: AND as_of_date = (
87: select max(as_of_date) from pa_progress_rollup
88: where project_id = p_project_id
89: and object_id = c_task_id
90: and object_type = 'PA_TASKS'
91: );

Line 96: FROM PA_PROGRESS_ROLLUP

92:
93: CURSOR get_task_act_dates_csr(c_task_id NUMBER)
94: IS
95: SELECT actual_start_date, actual_finish_date
96: FROM PA_PROGRESS_ROLLUP
97: WHERE project_id = p_project_id
98: AND object_id = c_task_id
99: AND object_type = 'PA_TASKS'
100: AND as_of_date = (

Line 101: select max(as_of_date) from pa_progress_rollup

97: WHERE project_id = p_project_id
98: AND object_id = c_task_id
99: AND object_type = 'PA_TASKS'
100: AND as_of_date = (
101: select max(as_of_date) from pa_progress_rollup
102: where project_id = p_project_id
103: and object_id = c_task_id
104: and object_type = 'PA_TASKS'
105: );