APPS.BSC_PERIODS_UTILITY_PKG dependencies on BSC_SYS_PERIODICITIES_VL

Line 66: FROM BSC_SYS_PERIODICITIES_VL P

62: BEGIN
63: l_Count := 0;
64:
65: SELECT COUNT(1) INTO l_Count
66: FROM BSC_SYS_PERIODICITIES_VL P
67: WHERE P.CALENDAR_ID = p_Calendar_Id
68: AND UPPER(P.NAME) = UPPER(p_Periodicity_Name);
69:
70:

Line 564: l_Name BSC_SYS_PERIODICITIES_VL.NAME%TYPE;

560: -- added for Bug#4574115
561: FUNCTION Get_Periodicity_Name (
562: p_Periodicity_Id IN NUMBER
563: ) RETURN VARCHAR2 IS
564: l_Name BSC_SYS_PERIODICITIES_VL.NAME%TYPE;
565: BEGIN
566: SELECT B.NAME
567: INTO l_Name
568: FROM BSC_SYS_PERIODICITIES_VL B

Line 568: FROM BSC_SYS_PERIODICITIES_VL B

564: l_Name BSC_SYS_PERIODICITIES_VL.NAME%TYPE;
565: BEGIN
566: SELECT B.NAME
567: INTO l_Name
568: FROM BSC_SYS_PERIODICITIES_VL B
569: WHERE B.PERIODICITY_ID = p_Periodicity_Id;
570:
571: RETURN l_Name;
572:

Line 581: l_Periodicity_Short_Name BSC_SYS_PERIODICITIES_VL.SHORT_NAME%TYPE;

577:
578: FUNCTION Get_Daily_Periodicity_Sht_Name(
579: p_Calendar_Id IN NUMBER
580: ) RETURN VARCHAR2 IS
581: l_Periodicity_Short_Name BSC_SYS_PERIODICITIES_VL.SHORT_NAME%TYPE;
582:
583: CURSOR c_CalendarPeriodicities IS
584: SELECT PERIODICITY_ID,
585: SHORT_NAME

Line 586: FROM BSC_SYS_PERIODICITIES_VL

582:
583: CURSOR c_CalendarPeriodicities IS
584: SELECT PERIODICITY_ID,
585: SHORT_NAME
586: FROM BSC_SYS_PERIODICITIES_VL
587: WHERE CALENDAR_id = p_Calendar_Id;
588:
589: BEGIN
590: FOR prdcty IN c_CalendarPeriodicities LOOP

Line 775: FROM BSC_SYS_PERIODICITIES_VL P

771: l_Data_Label VARCHAR2(100);
772:
773: CURSOR c_Get_Calendar_ID IS
774: SELECT P.CALENDAR_ID
775: FROM BSC_SYS_PERIODICITIES_VL P
776: WHERE P.SHORT_NAME = p_Dimension_Object_Short_Name;
777:
778: BEGIN
779: