APPS.ICX_ON_CABO dependencies on AK_REGIONS_VL

Line 93: from AK_REGIONS_VL

89: select REGION_APPLICATION_ID,REGION_CODE,
90: NAME,DESCRIPTION
91: into l_region_appl_id,l_region_code,
92: l_page_title,l_page_description
93: from AK_REGIONS_VL
94: where REGION_CODE = p_region_code
95: and REGION_APPLICATION_ID = p_region_appl_id;
96: end if;
97:

Line 513: from AK_REGIONS_VL

509:
510: /*
511: select NAME,DESCRIPTION
512: into l_region_title,l_region_description
513: from AK_REGIONS_VL
514: where REGION_CODE = p_region_code
515: and REGION_APPLICATION_ID = p_region_appl_id;
516: */
517:

Line 804: from AK_REGIONS_VL

800: then
801:
802: select DESCRIPTION
803: into l_region_description
804: from AK_REGIONS_VL
805: where REGION_APPLICATION_ID = ak_query_pkg.g_regions_table(r).region_application_id
806: and REGION_CODE = ak_query_pkg.g_regions_table(r).region_code;
807:
808: if l_region_description is not null