APPS.ICX_ON_CABO dependencies on AK_REGIONS

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 209: AK_REGIONS c,

205:
206: cursor FindAttributes is
207: select d.COLUMN_NAME,b.DATA_TYPE,a.ATTRIBUTE_LABEL_LONG,e.ICX_CUSTOM_CALL
208: from AK_ATTRIBUTES b,
209: AK_REGIONS c,
210: AK_OBJECT_ATTRIBUTES d,
211: AK_REGION_ITEMS e,
212: AK_REGION_ITEMS_VL a
213: where a.REGION_APPLICATION_ID = p_region_appl_id

Line 362: from ak_regions

358: --add section to block blind queries --mputman
359: --mputman changed block blind code 1747066
360: select icx_custom_call
361: into l_icx_custom_call
362: from ak_regions
363: where REGION_APPLICATION_ID = p_region_appl_id
364: and REGION_CODE = p_region_code;
365:
366: l_submit:=icx_cabo.g_plsql_agent||'OracleON.IC'; --mputman added 1747066

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