APPS.PA_PAGE_LAYOUT_PVT dependencies on DUAL

Line 45: select 'Y' from dual

41: AND lookup_code = p_page_type;
42:
43: CURSOR is_menu_id_required
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'

Line 248: select 'Y' from dual

244: l_req VARCHAR2(1);
245:
246: CURSOR is_menu_id_required
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'