APPS.PA_PAGE_LAYOUT_PVT dependencies on PA_LOOKUPS

Line 39: SELECT meaning FROM pa_lookups pl

35: l_dummy VARCHAR2(1);
36:
37: CURSOR get_template_type
38: is
39: SELECT meaning FROM pa_lookups pl
40: WHERE lookup_type = 'PA_PAGE_TYPES'
41: AND lookup_code = p_page_type;
42:
43: CURSOR is_menu_id_required

Line 48: from pa_lookups l

44: IS
45: select 'Y' from dual
46: where exists(
47: select 'Required'
48: from pa_lookups l
49: where l.lookup_type = 'PA_PAGE_TYPES'
50: and l.lookup_code = p_page_type
51: AND L.attribute2 = 'Y'
52: );

Line 251: from pa_lookups l, pa_page_layouts ppl

247: IS
248: select 'Y' from dual
249: where exists(
250: select 'Required'
251: from pa_lookups l, pa_page_layouts ppl
252: where l.lookup_type = 'PA_PAGE_TYPES'
253: and l.lookup_code = ppl.page_type_code
254: AND L.attribute2 = 'Y'
255: and ppl.page_id = p_page_id

Line 273: SELECT meaning FROM pa_lookups pl, pa_page_layouts ppl

269: l_page_layout_row_id ROWID;
270:
271: CURSOR get_template_type
272: is
273: SELECT meaning FROM pa_lookups pl, pa_page_layouts ppl
274: WHERE pl.lookup_type = 'PA_PAGE_TYPES'
275: AND pl.lookup_code = ppl.PAGE_TYPE_CODE
276: AND ppl.page_id = p_page_id;
277:

Line 463: SELECT meaning FROM pa_lookups pl, pa_page_layouts ppl

459: WHERE (page_id = p_page_id AND p_page_id IS NOT NULL);
460:
461: CURSOR get_template_type
462: is
463: SELECT meaning FROM pa_lookups pl, pa_page_layouts ppl
464: WHERE pl.lookup_type = 'PA_PAGE_TYPES'
465: AND pl.lookup_code = ppl.page_type_code
466: AND ppl.page_id = p_page_id;
467:

Line 642: SELECT meaning FROM pa_lookups pl, pa_page_layouts ppl

638: AND pptr.view_region_code = P_VIEW_REGION_CODE;
639:
640: CURSOR get_template_type
641: is
642: SELECT meaning FROM pa_lookups pl, pa_page_layouts ppl
643: WHERE pl.lookup_type = 'PA_PAGE_TYPES'
644: AND pl.lookup_code = ppl.page_type_code
645: AND ppl.page_id = p_page_id;
646: