APPS.PA_PROGRESS_UTILS dependencies on PA_OBJECT_PAGE_LAYOUTS

Line 168: FROM pa_object_page_layouts popl

164: object_id, object_type, reporting_cycle_id,
165: next_reporting_date, record_version_number,
166: initial_progress_status, final_progress_status,
167: rollup_progress_status, object_page_layout_id
168: FROM pa_object_page_layouts popl
169: WHERE
170: page_type_code = 'TPR'
171: AND page_id = -99
172: AND object_id = p_object_id

Line 267: FROM pa_object_page_layouts

263: -- wash-out all previously established savepoints. Not sure,whether to do this fix or not
264:
265: SELECT next_reporting_date, reporting_cycle_id, report_offset_days
266: INTO l_reporting_date, l_cycle_id, l_offset_days
267: FROM pa_object_page_layouts
268: WHERE object_id = p_project_id
269: AND object_type = 'PA_PROJECTS'
270: AND page_type_code = 'TPR';
271:

Line 285: UPDATE pa_object_page_layouts

281: ,l_reporting_date-1);
282:
283: End Loop;
284:
285: UPDATE pa_object_page_layouts
286: SET next_reporting_date = l_reporting_date
287: WHERE object_id = p_project_id
288: AND object_type = 'PA_PROJECTS'
289: AND page_type_code = 'TPR';