APPS.BIS_PMV_QUERY_PVT dependencies on BIS_AK_REGION_ITEM_EXTENSION

Line 783: -- report info from bis_ak_region_item_extension

779: l_sort_attribute VARCHAR2(2000);
780: l_sort_direction VARCHAR2(2000);
781: */
782:
783: -- report info from bis_ak_region_item_extension
784: CURSOR ak_region_item_ext_cursor (cpRegionCode VARCHAR2, cpAttributeCode VARCHAR2) IS
785: SELECT attribute16 extra_groupby
786: FROM BIS_AK_REGION_ITEM_EXTENSION
787: WHERE region_code = cpRegionCode

Line 786: FROM BIS_AK_REGION_ITEM_EXTENSION

782:
783: -- report info from bis_ak_region_item_extension
784: CURSOR ak_region_item_ext_cursor (cpRegionCode VARCHAR2, cpAttributeCode VARCHAR2) IS
785: SELECT attribute16 extra_groupby
786: FROM BIS_AK_REGION_ITEM_EXTENSION
787: WHERE region_code = cpRegionCode
788: AND attribute_code = cpAttributeCode;
789:
790: l_ak_region_item_ext_rec BIS_PMV_METADATA_PVT.AK_REGION_ITEM_EXT_REC;

Line 1127: --get info from bis_ak_region_item_extension

1123: l_viewby_id_name := 'ID';
1124: l_viewby_value_name := 'VALUE';
1125: end if;
1126:
1127: --get info from bis_ak_region_item_extension
1128: if ak_region_item_ext_cursor%ISOPEN then
1129: close ak_region_item_ext_cursor;
1130: end if;
1131: open ak_region_item_ext_cursor(l_user_session_rec.region_code, l_viewby_attribute_code);