APPS.PA_REPORT_WORKFLOW_CLIENT dependencies on PA_OBJECT_PAGE_LAYOUTS

Line 403: FROM pa_object_page_layouts popl, pa_progress_report_vers pprv

399:
400:
401: CURSOR get_approval_required IS
402: SELECT popl.approval_required
403: FROM pa_object_page_layouts popl, pa_progress_report_vers pprv
404: WHERE pprv.version_id = p_version_id
405: AND popl.object_id = pprv.object_id
406: AND popl.object_type = pprv.object_type
407: AND popl.page_id = pprv.page_id

Line 897: pa_object_page_layouts popl

893: IS
894: select approver_source_id,
895: approver_source_type
896: from pa_progress_report_vers pprv,
897: pa_object_page_layouts popl
898: where pprv.object_id = popl.object_id
899: and pprv.object_type = popl.object_type
900: and pprv.report_type_id = popl.report_type_id
901: and version_id = l_version_id;

Line 1168: from pa_object_page_layouts popl,

1164:
1165: CURSOR get_object_page_layout_id
1166: IS
1167: select popl.object_page_layout_id
1168: from pa_object_page_layouts popl,
1169: pa_progress_report_vers pprv
1170: where popl.object_id = l_project_id
1171: and popl.object_type = 'PA_PROJECTS'
1172: and popl.page_type_code = 'PPR'