APPS.BSC_CALENDAR_PUB dependencies on BSC_SYS_CALENDARS_VL

Line 204: FROM bsc_sys_calendars_vl

200: INTO l_Fiscal_Year
201: ,l_Start_Month
202: ,l_Start_Day
203: ,l_Calendar_Old_Name
204: FROM bsc_sys_calendars_vl
205: WHERE calendar_id = p_Calendar_Record.Calendar_Id;
206:
207: -- added for Bug#4565308
208: IF((l_Fiscal_Year <> p_Calendar_Record.Fiscal_Year)

Line 561: FROM bsc_sys_calendars_vl

557: END IF;
558:
559: SELECT COUNT(1)
560: INTO l_count
561: FROM bsc_sys_calendars_vl
562: WHERE TRIM(NAME) = TRIM(p_Calendar_Record.Name);
563: IF(l_count > 0)THEN
564: FND_MESSAGE.SET_NAME('BSC','BSC_CALENDAR_EXISTS');
565: FND_MESSAGE.SET_TOKEN('CALENDAR_NAME',TRIM(p_Calendar_Record.Name));

Line 621: FROM bsc_sys_calendars_vl

617: AND S.CALENDAR_ID = p_Calendar_Record.Calendar_Id;
618:
619: SELECT name
620: INTO l_Calendar_Name
621: FROM bsc_sys_calendars_vl
622: WHERE calendar_id = p_Calendar_Record.Calendar_Id;
623:
624: IF (l_count <> 0) THEN
625: FOR cObj IN C_Objectives LOOP

Line 730: FROM bsc_sys_calendars_vl

726: , x_Calendar_Record.Creation_Date
727: , x_Calendar_Record.Last_Updated_By
728: , x_Calendar_Record.Last_Update_Date
729: , x_Calendar_Record.Last_Update_Login
730: FROM bsc_sys_calendars_vl
731: WHERE calendar_id = p_Calendar_Record.Calendar_Id;
732:
733:
734: IF(p_Calendar_Record.Name <> x_Calendar_Record.Name) THEN