DBA Data[Home] [Help]

APPS.ORACLEMYPAGE dependencies on ICX_PAGES_TL

Line 744: icx_pages_tl ipt

740:
741: cursor getPages (p_user_id number) is
742: select ip.page_id, ipt.page_name, ip.main_region_id, ip.page_code, ip.page_type
743: from icx_pages ip,
744: icx_pages_tl ipt
745: where ip.user_id = p_user_id
746: and ipt.language = userenv('LANG')
747: and ip.page_id = ipt.page_id
748: and ip.page_type in ('USER', 'MAIN')

Line 1222: icx_pages_tl ipt

1218:
1219: cursor getPages (p_user_id number) is
1220: select ip.page_id, ipt.page_name, ip.main_region_id, ip.page_code, ip.page_type
1221: from icx_pages ip,
1222: icx_pages_tl ipt
1223: where ip.user_id = p_user_id
1224: and ipt.language = userenv('LANG')
1225: and ip.page_id = ipt.page_id
1226: and ip.page_type in ('USER', 'MAIN')