44: LOV_ATTRIBUTE_CODE,
45: BASE_ATTRIBUTE_APPL_ID,
46: BASE_ATTRIBUTE_CODE,
47: DIRECTION_FLAG
48: from AK_REGION_LOV_RELATIONS
49: where REGION_APPLICATION_ID = 660
50: and REGION_CODE = x_region_name
51: and ATTRIBUTE_CODE = x_attribute_code;
52:
122: EXIT WHEN ak_region_items%NOTFOUND;
123:
124: select count(*)
125: into mycount
126: from AK_REGION_LOV_RELATIONS
127: where REGION_APPLICATION_ID = 660
128: and REGION_CODE = p_region_code
129: and ATTRIBUTE_CODE = p_attribute_code;
130: