DBA Data[Home] [Help]

APPS.PA_TASK_PROG_ACTSET dependencies on PA_OBJECT_PAGE_LAYOUTS

Line 260: FROM pa_object_page_layouts

256: l_sysdate DATE := TRUNC(sysdate);
257:
258: CURSOR c_proj_date(cp_project_id NUMBER) IS
259: SELECT next_reporting_date report_date
260: FROM pa_object_page_layouts
261: WHERE TRUNC(next_reporting_date) = l_sysdate
262: AND object_id = cp_project_id
263: AND object_type = 'PA_PROJECTS'
264: AND page_type_code = 'TPR';