DBA Data[Home] [Help]

APPS.PA_PAGE_LAYOUT_PVT dependencies on PA_PAGE_TYPE_REGIONS

Line 634: FROM pa_page_type_regions pptr, pa_page_layouts ppl

630:
631: CURSOR get_edit_region_code
632: IS
633: SELECT view_region_code, edit_region_code
634: FROM pa_page_type_regions pptr, pa_page_layouts ppl
635: WHERE pptr.page_type_code = ppl.page_type_code
636: AND ppl.page_id = p_page_id
637: AND pptr.region_source_type = P_REGION_SOURCE_TYPE
638: AND pptr.view_region_code = P_VIEW_REGION_CODE;

Line 878: , pa_page_type_regions pptr

874: , pplr.region_source_code
875: , pplr.record_version_number
876: FROM pa_page_layout_regions pplr
877: , pa_page_layouts ppl
878: , pa_page_type_regions pptr
879: WHERE pplr.page_id = p_page_id
880: and ppl.page_id = pplr.page_id
881: and ppl.page_type_code = pptr.page_type_code
882: and pplr.region_source_type = pptr.region_source_type