APPS.ICX_ON_UTILITIES dependencies on AK_REGIONS_VL

Line 42: from AK_REGIONS_VL

38: else
39:
40: select NAME
41: into l_page_title
42: from AK_REGIONS_VL
43: where REGION_CODE = p_region_code
44: and REGION_APPLICATION_ID = p_region_appl_id;
45:
46: l_region_appl_id := p_region_appl_id;

Line 627: from AK_REGIONS_VL

623: end if;
624:
625: select NAME,DESCRIPTION
626: into l_region_title,l_region_description
627: from AK_REGIONS_VL
628: where REGION_CODE = l_region_code
629: and REGION_APPLICATION_ID = p_region_appl_id;
630:
631: if l_data_type1 = 'V'

Line 1351: from AK_REGIONS_VL

1347: then
1348:
1349: select DESCRIPTION
1350: into l_region_description
1351: from AK_REGIONS_VL
1352: where REGION_APPLICATION_ID = ak_query_pkg.g_regions_table(r).region_application_id
1353: and REGION_CODE = ak_query_pkg.g_regions_table(r).region_code;
1354:
1355: if l_region_description is not null