APPS.BSC_PERIODS_PUB dependencies on BIS_LEVELS

Line 95: l_table_name BIS_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;

91: RETURN VARCHAR2 IS
92: l_found BOOLEAN;
93: l_alias VARCHAR2(30);
94: l_count NUMBER;
95: l_table_name BIS_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;
96: BEGIN
97:
98: l_found := TRUE;
99: l_alias := NULL;

Line 104: FROM bis_levels

100: l_table_name := 'BSC_P_' || SUBSTR(p_short_name , 1, 22) || '_V';
101: WHILE (l_found) LOOP
102: SELECT COUNT(1)
103: INTO l_count
104: FROM bis_levels
105: WHERE level_values_view_name = l_table_name;
106: IF (l_count = 0) THEN
107: l_found := FALSE;
108: END IF;

Line 589: l_View_Name BIS_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;

585: , x_Msg_Count OUT NOCOPY NUMBER
586: , x_Msg_Data OUT NOCOPY VARCHAR2
587: )IS
588: l_Sql_Stmt VARCHAR2(32000);
589: l_View_Name BIS_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;
590: l_Period_DB_Col BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;
591:
592: BEGIN
593: --dbms_output.put_line('START :Create_Periodicity_View :- ' ||DBMS_UTILITY.GET_TIME);