APPS.PA_PROGRESS_REPORT_WORKFLOW dependencies on PA_OBJECT_PAGE_LAYOUTS

Line 503: (SELECT * FROM pa_progress_report_vers pprv, pa_object_page_layouts popl

499: CURSOR is_auto_published IS
500: SELECT 'Y'
501: FROM dual
502: WHERE exists
503: (SELECT * FROM pa_progress_report_vers pprv, pa_object_page_layouts popl
504: WHERE pprv.version_id = l_version_id
505: AND pprv.object_id = popl.object_id
506: AND pprv.object_type = popl.object_type
507: AND popl.approval_required = 'A');

Line 735: FROM pa_project_lists_v pplv, pa_object_page_layouts popl, pa_report_types prt

731: pplv.carrying_out_organization_name,
732: pplv.name || '(' || pplv.segment1 || ')',
733: prt.name,
734: pplv.project_id
735: FROM pa_project_lists_v pplv, pa_object_page_layouts popl, pa_report_types prt
736: WHERE pplv.project_id = popl.object_id
737: AND popl.object_page_layout_id = p_object_id
738: AND popl.object_type = 'PA_PROJECTS'
739: and nvl(popl.report_type_id, 1) = prt.report_type_id

Line 748: FROM pa_object_page_layouts

744: report_type_id,
745: reporting_cycle_id,
746: report_offset_days,
747: effective_from
748: FROM pa_object_page_layouts
749: WHERE
750: object_page_layout_id = p_object_id
751: and
752: page_type_code = 'PPR';

Line 1036: FROM pa_object_page_layouts

1032:
1033: CURSOR get_obj_page_layout_info
1034: IS
1035: SELECT object_id, reminder_days, next_reporting_date
1036: FROM pa_object_page_layouts
1037: WHERE object_page_layout_id = l_object_id
1038: AND object_type = 'PA_PROJECTS';
1039:
1040:

Line 1249: FROM pa_object_page_layouts

1245:
1246: CURSOR get_obj_page_layout_info
1247: IS
1248: SELECT object_id, reminder_days, next_reporting_date
1249: FROM pa_object_page_layouts
1250: WHERE object_page_layout_id = l_object_id
1251: AND object_type = 'PA_PROJECTS';
1252:
1253: CURSOR l_report_approver_csr_person IS