APPS.ICX_REQ_SEARCH dependencies on AK_REGIONS

Line 191: AK_REGIONS c,

187:
188: cursor FindAttributes is
189: select d.COLUMN_NAME,b.DATA_TYPE,a.ATTRIBUTE_LABEL_LONG
190: from AK_ATTRIBUTES b,
191: AK_REGIONS c,
192: AK_OBJECT_ATTRIBUTES d,
193: AK_REGION_ITEMS_VL a
194: where a.REGION_APPLICATION_ID = p_region_appl_id
195: and a.REGION_CODE = p_region_code

Line 323: from AK_REGIONS_VL

319: then
320:
321: select NAME
322: into l_page_title
323: from AK_REGIONS_VL
324: where REGION_CODE = p_region_code
325: and REGION_APPLICATION_ID = p_region_appl_id;
326:
327: fnd_message.set_name('ICX','ICX_FIND_TEXT');