DBA Data[Home] [Help]

APPS.BSC_PERIODICITIES_PUB dependencies on BSC_SYS_CALENDARS_VL

Line 474: l_dim_name BSC_SYS_CALENDARS_VL.NAME%TYPE;

470: ) IS
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

Line 511: FROM bsc_sys_calendars_vl c

507: IF(l_regions IS NOT NULL) THEN
508:
509: SELECT c.name
510: INTO l_dim_name
511: FROM bsc_sys_calendars_vl c
512: WHERE c.short_name = l_Dimension_SN;
513:
514: SELECT c.name
515: INTO l_dim_obj_name