APPS.ICX_DEFINE_PAGES dependencies on ICX_PAGES_TL

Line 69: icx_pages_tl ipt

65:
66: cursor wlistcurs is
67: select ip.page_id, ipt.page_name, ip.page_type
68: from icx_pages ip,
69: icx_pages_tl ipt
70: where ip.user_id = l_user_id
71: and ipt.language = userenv('LANG')
72: and ip.page_id = ipt.page_id
73: and ip.page_type in ('USER', 'SEED')

Line 90: from icx_pages_tl

86: if (p_page_id IS NOT NULL) then
87:
88: select MAX(page_name)
89: into l_page_name
90: from icx_pages_tl
91: where page_id = p_page_id
92: and language = userenv('LANG');
93:
94: end if;

Line 483: icx_pages_tl ipt

479:
480: cursor wlistcurs is
481: select ip.page_id, ipt.page_name
482: from icx_pages ip,
483: icx_pages_tl ipt
484: where ip.user_id = l_user_id
485: and ipt.language = userenv('LANG')
486: and ip.page_id = ipt.page_id
487: and ip.page_type = 'USER'