DBA Data[Home] [Help]

APPS.PA_REPORT_WORKFLOW_CLIENT dependencies on PA_OBJECT_PAGE_LAYOUTS

Line 412: FROM pa_object_page_layouts popl, pa_progress_report_vers pprv

408:
409:
410: CURSOR get_approval_required IS
411: SELECT popl.approval_required
412: FROM pa_object_page_layouts popl, pa_progress_report_vers pprv
413: WHERE pprv.version_id = p_version_id
414: AND popl.object_id = pprv.object_id
415: AND popl.object_type = pprv.object_type
416: AND popl.page_id = pprv.page_id

Line 925: pa_object_page_layouts popl

921: IS
922: select approver_source_id,
923: approver_source_type
924: from pa_progress_report_vers pprv,
925: pa_object_page_layouts popl
926: where pprv.object_id = popl.object_id
927: and pprv.object_type = popl.object_type
928: and pprv.report_type_id = popl.report_type_id
929: and version_id = l_version_id;

Line 1218: from pa_object_page_layouts popl,

1214:
1215: CURSOR get_object_page_layout_id
1216: IS
1217: select popl.object_page_layout_id
1218: from pa_object_page_layouts popl,
1219: pa_progress_report_vers pprv
1220: where popl.object_id = l_project_id
1221: and popl.object_type = 'PA_PROJECTS'
1222: and popl.page_type_code = 'PPR'