DBA Data[Home] [Help]

APPS.BIS_PMV_PARAMETERS_PVT dependencies on BIS_AK_REGION_ITEM_EXTENSION

Line 2057: select attribute17 from bis_ak_region_item_extension ext

2053: --BugFix 3497180
2054: l_rolling_dim varchar2(250);
2055:
2056: cursor c_rolling_dim is
2057: select attribute17 from bis_ak_region_item_extension ext
2058: where ext.region_code=p_user_session_rec.region_code
2059: and attribute_code =
2060: ( select attribute_code from ak_region_items akItems
2061: where akItems.region_code= ext.region_code

Line 2226: FROM bis_ak_region_item_extension

2222: WHERE region_code = pRegionCode;
2223:
2224: CURSOR getPrivileges(pAttributeCode VARCHAR2) IS
2225: SELECT attribute24
2226: FROM bis_ak_region_item_extension
2227: WHERE region_code=pRegionCode AND attribute_code=pAttributeCode;
2228:
2229: cursor c_level_values_view_name (cp_parameter_name varchar2, cp_region_code varchar2) is
2230: select vl.attribute15, -- level view name

Line 6061: FROM ak_region_items a, bis_ak_region_item_extension c

6057: */
6058: -- nbarik - 03/29/04 - Parameter Validation while navigating through related links
6059: CURSOR c_validation_parameters IS
6060: SELECT a.attribute2, c.attribute26
6061: FROM ak_region_items a, bis_ak_region_item_extension c
6062: WHERE a.region_code=pParamRegionCode AND a.attribute_code=c.attribute_code(+) AND a.region_code=c.region_code(+);
6063:
6064: lValidationAttrList BISVIEWER.t_char;
6065: lValidationReqList BISVIEWER.t_char;