APPS.POR_LOV_PKG dependencies on AK_REGION_ITEMS

Line 81: AK_REGION_ITEMS_VL b,

77: cursor lov_query_columns is
78: select d.COLUMN_NAME,b.ATTRIBUTE_LABEL_LONG,
79: substr(a.DATA_TYPE,1,1)
80: from AK_ATTRIBUTES a,
81: AK_REGION_ITEMS_VL b,
82: AK_REGIONS c,
83: AK_OBJECT_ATTRIBUTES d
84: where b.REGION_APPLICATION_ID = l_LOV_region_id
85: and b.REGION_CODE = l_LOV_region

Line 118: from AK_REGION_ITEMS

114:
115: -- Look up the LOV region being called
116: select LOV_FOREIGN_KEY_NAME, LOV_REGION_APPLICATION_ID, LOV_REGION_CODE
117: into l_LOV_foreign_key_name, l_LOV_region_id, l_LOV_region
118: from AK_REGION_ITEMS
119: where REGION_APPLICATION_ID = p_region_app_id
120: and REGION_CODE = p_region_code
121: and ATTRIBUTE_APPLICATION_ID = p_attribute_app_id
122: and ATTRIBUTE_CODE = p_attribute_code;