APPS.BSC_UPDATE_UTIL dependencies on BSC_SYS_CALENDARS_VL

Line 1998: ' FROM BSC_SYS_CALENDARS_VL C, BSC_EDW_CALENDAR_TYPE_VL T'||

1994:
1995: BEGIN
1996: /*
1997: h_sql := 'SELECT DECODE(C.EDW_FLAG, 0, C.NAME, C.NAME||'' (''||T.NAME||'')'')'||
1998: ' FROM BSC_SYS_CALENDARS_VL C, BSC_EDW_CALENDAR_TYPE_VL T'||
1999: ' WHERE C.CALENDAR_ID = :1 AND C.EDW_CALENDAR_TYPE_ID = T.EDW_CALENDAR_TYPE_ID (+)';
2000: OPEN h_cursor FOR h_sql USING x_calendar_id;
2001: FETCH h_cursor INTO h_calendar_name;
2002: CLOSE h_cursor;

Line 2006: FROM BSC_SYS_CALENDARS_VL C, BSC_EDW_CALENDAR_TYPE_VL T

2002: CLOSE h_cursor;
2003: */
2004: SELECT DECODE(C.EDW_FLAG, 0, C.NAME, C.NAME||' ('||T.NAME||')')
2005: INTO h_calendar_name
2006: FROM BSC_SYS_CALENDARS_VL C, BSC_EDW_CALENDAR_TYPE_VL T
2007: WHERE C.CALENDAR_ID = x_calendar_id AND C.EDW_CALENDAR_TYPE_ID = T.EDW_CALENDAR_TYPE_ID (+);
2008:
2009: RETURN h_calendar_name;
2010: