APPS.BSC_PERIODICITIES_PUB dependencies on BSC_SYS_PERIODICITIES_VL

Line 475: l_dim_obj_name BSC_SYS_PERIODICITIES_VL.NAME%TYPE;

471: l_Dim_Object_SN BSC_SYS_PERIODICITIES.SHORT_NAME%TYPE;
472: l_Dimension_SN BSC_SYS_CALENDARS_B.SHORT_NAME%TYPE;
473: l_Periodicity_View_Name VARCHAR2(30);
474: l_dim_name BSC_SYS_CALENDARS_VL.NAME%TYPE;
475: l_dim_obj_name BSC_SYS_PERIODICITIES_VL.NAME%TYPE;
476: l_regions VARCHAR2(32000);
477:
478: CURSOR c_Delete_View IS
479: SELECT L.LEVEL_VALUES_VIEW_NAME

Line 516: FROM bsc_sys_periodicities_vl c

512: WHERE c.short_name = l_Dimension_SN;
513:
514: SELECT c.name
515: INTO l_dim_obj_name
516: FROM bsc_sys_periodicities_vl c
517: WHERE c.short_name = l_Dim_Object_SN;
518:
519: FND_MESSAGE.SET_NAME('BIS','BIS_DIM_OBJ_RPTASSOC_ERROR');
520: FND_MESSAGE.SET_TOKEN('DIM_NAME', l_dim_obj_name);

Line 780: FROM BSC_SYS_PERIODICITIES_VL P

776:
777: IF (p_Action_Type = BSC_PERIODS_UTILITY_PKG.C_UPDATE) THEN
778:
779: SELECT COUNT(1) INTO l_Count
780: FROM BSC_SYS_PERIODICITIES_VL P
781: WHERE P.NAME = p_Periodicities_Rec_Type.Name
782: AND P.CALENDAR_ID = p_Periodicities_Rec_Type.Calendar_Id
783: AND P.PERIODICITY_ID <> p_Periodicities_Rec_Type.Periodicity_id;
784: