APPS.PA_DISTRIBUTION_LIST_UTILS dependencies on PA_OBJECT_PAGE_LAYOUTS

Line 232: FROM pa_object_page_layouts

228: IF p_context_object_type IS NULL AND
229: p_object_type = 'PA_OBJECT_PAGE_LAYOUT' THEN
230: SELECT object_type, object_id
231: INTO l_object_type, l_object_id
232: FROM pa_object_page_layouts
233: WHERE object_page_layout_id = p_object_id;
234: END IF;
235:
236: l_resource_id := pa_resource_utils.get_resource_id(NULL,p_user_id); -- Bug 2717635

Line 380: FROM pa_object_page_layouts

376:
377: IF p_object_type = 'PA_OBJECT_PAGE_LAYOUT' THEN
378: SELECT object_type, object_id
379: INTO l_object_type, l_object_id
380: FROM pa_object_page_layouts
381: WHERE object_page_layout_id = p_object_id;
382: --dbms_output.put_line('object_id='||l_object_id);
383: ELSE
384: --dbms_output.put_line('unhandled object type');

Line 570: FROM pa_object_page_layouts

566:
567: IF p_object_type = 'PA_OBJECT_PAGE_LAYOUT' THEN
568: SELECT object_type, object_id
569: INTO l_object_type, l_object_id
570: FROM pa_object_page_layouts
571: WHERE object_page_layout_id = p_object_id;
572:
573: ELSE
574: x_return_status := 'U';

Line 652: FROM pa_object_page_layouts

648:
649:
650:
651: CURSOR get_object IS SELECT object_id, object_type
652: FROM pa_object_page_layouts
653: WHERE page_type_code = 'PPR'
654: AND object_page_layout_id = p_object_id_to;
655:
656: CURSOR get_list_id_from IS SELECT list_id