DBA Data[Home] [Help]

APPS.BSC_CALENDAR_PUB dependencies on BIS_LEVELS

Line 350: bis_levels B

346:
347: CURSOR C_Per_Views IS
348: SELECT B.level_values_view_name
349: FROM bsc_sys_periodicities P,
350: bis_levels B
351: WHERE b.short_name = P.short_name
352: AND P.calendar_id = p_Calendar_Record.Calendar_Id
353: AND P.db_column_name IS NOT NULL;
354:

Line 363: l_DimObj_ViewName BIS_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;

359:
360: l_Views_Array varchar2_tabletype;
361: l_Comma_Per_ShortNames VARCHAR2(32000);
362: l_Calendar_ShortName BSC_SYS_CALENDARS_B.SHORT_NAME%TYPE;
363: l_DimObj_ViewName BIS_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;
364: l_count NUMBER;
365:
366: BEGIN
367: SAVEPOINT DeleteCalendarPubSP;