APPS.BIS_DIM_LEVEL_VALUE_PVT dependencies on BISBV_DIMENSION_LEVELS

Line 98: FROM BISBV_DIMENSION_LEVELS

94: INTO
95: l_short_name
96: , l_name
97: , l_view_name
98: FROM BISBV_DIMENSION_LEVELS
99: WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
100: --
101: IF(l_short_name <> 'TOTAL_ORGANIZATIONS') THEN
102: -- create the resps clause

Line 276: FROM BISBV_DIMENSION_LEVELS

272: INTO
273: l_short_name
274: , l_name
275: , l_view_name
276: FROM BISBV_DIMENSION_LEVELS
277: WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
278: --
279: IF(l_short_name <> 'TOTAL_ORGANIZATIONS') THEN
280: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

Line 432: FROM BISBV_DIMENSION_LEVELS

428: INTO
429: l_short_name
430: , l_name
431: , l_view_name
432: FROM BISBV_DIMENSION_LEVELS
433: WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
434: --
435: IF(l_short_name <> 'TOTAL_ORGANIZATIONS') THEN
436: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

Line 572: FROM BISBV_DIMENSION_LEVELS

568: INTO
569: l_short_name
570: , l_name
571: , l_view_name
572: FROM BISBV_DIMENSION_LEVELS
573: WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
574: --
575: IF(SUBSTR(l_short_name, 1, 5) <> 'TOTAL') THEN
576: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

Line 720: FROM BISBV_DIMENSION_LEVELS

716: INTO
717: l_short_name
718: , l_name
719: , l_view_name
720: FROM BISBV_DIMENSION_LEVELS
721: WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
722: --
723: IF(l_short_name <> 'TOTAL_TIME') THEN
724: IF (BIS_UTILITIES_PUB.is_time_dependent_on_org(p_time_lvl_short_name => l_short_name)

Line 935: FROM BISBV_DIMENSION_LEVELS

931: , LEVEL_VALUES_VIEW_NAME
932: INTO
933: l_short_name
934: , l_view_name
935: FROM BISBV_DIMENSION_LEVELS
936: WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
937: --
938: --
939: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

Line 1039: FROM BISBV_DIMENSION_LEVELS

1035: , LEVEL_VALUES_VIEW_NAME
1036: INTO
1037: l_short_name
1038: , l_view_name
1039: FROM BISBV_DIMENSION_LEVELS
1040: WHERE DIMENSION_LEVEL_ID = p_Dimension_Level_Rec.Dimension_Level_ID;
1041: --
1042: --
1043: IF(DBMS_SQL.IS_OPEN(l_cursor)) THEN

Line 1143: FROM BISBV_DIMENSION_LEVELS

1139: INTO
1140: l_short_name
1141: , l_name
1142: , l_view_name
1143: FROM BISBV_DIMENSION_LEVELS
1144: WHERE DIMENSION_LEVEL_ID = p_Dim_Level_Value_Rec.Dimension_Level_ID;
1145: --
1146: IF(l_short_name <> 'TOTAL_ORGANIZATIONS') THEN
1147: --

Line 1244: FROM BISBV_DIMENSION_LEVELS

1240: INTO
1241: l_short_name
1242: , l_name
1243: , l_view_name
1244: FROM BISBV_DIMENSION_LEVELS
1245: WHERE DIMENSION_LEVEL_ID = p_Dim_Level_Value_Rec.Dimension_Level_ID;
1246: --
1247: IF(l_short_name <> 'TOTAL_ORGANIZATIONS') THEN
1248: --

Line 1348: FROM BISBV_DIMENSION_LEVELS

1344: INTO
1345: l_short_name
1346: , l_name
1347: , l_view_name
1348: FROM BISBV_DIMENSION_LEVELS
1349: WHERE DIMENSION_LEVEL_ID = p_Dim_Level_Value_Rec.Dimension_Level_ID;
1350: --
1351: IF(l_short_name <> 'TOTAL_TIME') THEN
1352: --

Line 1471: FROM BISBV_DIMENSION_LEVELS

1467: INTO
1468: l_short_name
1469: , l_name
1470: , l_view_name
1471: FROM BISBV_DIMENSION_LEVELS
1472: WHERE DIMENSION_LEVEL_ID = p_Dim_Level_Value_Rec.Dimension_Level_ID;
1473: --
1474: IF(l_short_name <> 'TOTAL_TIME') THEN
1475: --

Line 1753: FROM BISBV_DIMENSION_LEVELS

1749: INTO
1750: l_short_name
1751: , l_name
1752: , l_view_name
1753: FROM BISBV_DIMENSION_LEVELS
1754: WHERE DIMENSION_LEVEL_ID = p_Dim_Level_Value_Rec.Dimension_Level_ID;
1755: --
1756: IF(SUBSTR(l_short_name, 1, 5) <> 'TOTAL') THEN
1757: l_select_stmt := 'SELECT DISTINCT ID, VALUE FROM '|| l_view_name