DBA Data[Home] [Help]

APPS.PA_PROGRESS_REPORT_WORKFLOW dependencies on PA_REPORT_TYPES

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