APPS.PA_DISTRIBUTION_LIST_UTILS dependencies on PA_OBJECT_PAGE_LAYOUTS

Line 265: FROM pa_object_page_layouts

261: IF p_context_object_type IS NULL AND
262: p_object_type = 'PA_OBJECT_PAGE_LAYOUT' THEN
263: SELECT object_type, object_id
264: INTO l_object_type, l_object_id
265: FROM pa_object_page_layouts
266: WHERE object_page_layout_id = p_object_id;
267: END IF;
268:
269: l_resource_id := pa_resource_utils.get_resource_id(NULL,p_user_id); -- Bug 2717635

Line 413: FROM pa_object_page_layouts

409:
410: IF p_object_type = 'PA_OBJECT_PAGE_LAYOUT' THEN
411: SELECT object_type, object_id
412: INTO l_object_type, l_object_id
413: FROM pa_object_page_layouts
414: WHERE object_page_layout_id = p_object_id;
415: --dbms_output.put_line('object_id='||l_object_id);
416: ELSE
417: --dbms_output.put_line('unhandled object type');

Line 603: FROM pa_object_page_layouts

599:
600: IF p_object_type = 'PA_OBJECT_PAGE_LAYOUT' THEN
601: SELECT object_type, object_id
602: INTO l_object_type, l_object_id
603: FROM pa_object_page_layouts
604: WHERE object_page_layout_id = p_object_id;
605:
606: ELSE
607: x_return_status := 'U';

Line 685: FROM pa_object_page_layouts

681:
682:
683:
684: CURSOR get_object IS SELECT object_id, object_type
685: FROM pa_object_page_layouts
686: WHERE page_type_code = 'PPR'
687: AND object_page_layout_id = p_object_id_to;
688:
689: CURSOR get_list_id_from IS SELECT list_id