DBA Data[Home] [Help]

APPS.BIS_PMV_UTIL dependencies on AK_REGION_ITEMS

Line 265: ak_region_items

261: pRegionCode in varchar2) RETURN VARCHAR2
262: IS
263: CURSOR cAttr2 IS
264: SELECT attribute2 FROM
265: ak_region_items
266: WHERE region_code=rtrim(ltrim(pRegionCode)) and
267: (ltrim(rtrim(pAttributeCode)) in (attribute_code, attribute_code||'_FROM',
268: attribute_code||'_TO', attribute_code||'_HIERARCHY'));
269: l_attribute2 varchar2(32000);

Line 289: ak_region_items

285: pRegionCode in varchar2) RETURN VARCHAR2
286: IS
287: CURSOR cAttr2 IS
288: SELECT attribute_code FROM
289: ak_region_items
290: WHERE region_code=rtrim(ltrim(pRegionCode)) and
291: attribute2=ltrim(rtrim(pDimension));
292: l_attribute_code varchar2(32000);
293: BEGIN