APPS.BSC_MO_DOC_PKG dependencies on BSC_SYS_PERIODICITIES_VL

Line 24: , BSC_SYS_PERIODICITIES_VL per

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;
28: TYPE l_table IS TABLE OF perCal%ROWTYPE;

Line 201: SELECT NAME FROM BSC_SYS_PERIODICITIES_VL

197: -- Periodicity: periodicity code
198: --****************************************************************************
199: Function GetPeriodicityName(Periodicity IN NUMBER) RETURN VARCHAR2 IS
200: CURSOR c1 IS
201: SELECT NAME FROM BSC_SYS_PERIODICITIES_VL
202: WHERE PERIODICITY_ID = Periodicity;
203: l_name varchar2(100) := null ;
204:
205: BEGIN

Line 235: FROM BSC_SYS_PERIODICITIES_VL

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);
237:
238: l_name VARCHAR2(100);
239: BEGIN