APPS.ICX_UTIL dependencies on AK_REGION_ITEMS_TL

Line 1911: from ak_region_items_tl arit,

1907: l_count number;
1908:
1909: cursor items is -- removed select for ari.attribute_code since we didnt use it. mputman 1574527
1910: select arit.attribute_label_long
1911: from ak_region_items_tl arit,
1912: ak_region_items ari
1913: where
1914: arit.region_application_id = ari.region_application_id
1915: and arit.region_code = ari.region_code

Line 1925: from AK_REGION_ITEMS_TL a,

1921: order by display_sequence;
1922:
1923: cursor items_base is
1924: select a.ATTRIBUTE_LABEL_LONG,a.ATTRIBUTE_CODE
1925: from AK_REGION_ITEMS_TL a,
1926: AK_REGION_ITEMS b,
1927: FND_LANGUAGES c
1928: where b.REGION_APPLICATION_ID = p_region_application_id
1929: and b.REGION_CODE = p_region_code

Line 2010: from AK_REGION_ITEMS_TL a,

2006: when NO_DATA_FOUND then
2007: begin
2008: select ATTRIBUTE_LABEL_LONG
2009: into l_prompt
2010: from AK_REGION_ITEMS_TL a,
2011: FND_LANGUAGES b
2012: where REGION_APPLICATION_ID = p_region_application_id
2013: and REGION_CODE = p_region_code
2014: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id