APPS.BSC_MO_DOC_PKG dependencies on BSC_SYS_CALENDARS_VL

Line 23: FROM BSC_SYS_CALENDARS_VL cal

19:
20: PROCEDURE InitializePerCalMap IS
21: CURSOR perCal is
22: SELECT periodicity_id, per.name periodicity_name, cal.calendar_id, cal.NAME calendar_name
23: FROM BSC_SYS_CALENDARS_VL cal
24: , BSC_SYS_PERIODICITIES_VL per
25: WHERE per.CALENDAR_ID = cal.calendar_id
26: order by periodicity_id;
27: --TYPE l_record IS perCal%ROWTYPE;

Line 232: SELECT NAME FROM BSC_SYS_CALENDARS_VL

228: --Fix bug#1928043
229: --GetPeriodicityCalendarName = gCalendars(Trim(gPeriodicityes(Trim(periodicity_id)).Calendar_id)).Name
230:
231: CURSOR c1 (p1 NUMBER) IS
232: SELECT NAME FROM BSC_SYS_CALENDARS_VL
233: WHERE CALENDAR_ID = (
234: SELECT CALENDAR_ID
235: FROM BSC_SYS_PERIODICITIES_VL
236: WHERE PERIODICITY_ID = p1);