APPS.BSC_SEC_UTILITY dependencies on BSC_SYS_COM_DIM_LEVELS

Line 79: bsc_sys_com_dim_levels

75: max(DIM_LEVEL_INDEX)
76: into
77: l_dim_ind
78: from
79: bsc_sys_com_dim_levels
80: where tab_id=p_tab_id;
81: **/
82: return l_dim_ind;
83: exception

Line 97: bsc_sys_com_dim_levels a,

93: cursor c_level_view is
94: select
95: b.LEVEL_VIEW_NAME
96: from
97: bsc_sys_com_dim_levels a,
98: bsc_sys_dim_levels_vl b
99: where
100: a.tab_id=p_tab_id
101: and a.DIM_LEVEL_INDEX=p_level_index

Line 108: bsc_sys_com_dim_levels a,

104: cursor c_parent_pk is
105: select
106: b.LEVEL_PK_COL
107: from
108: bsc_sys_com_dim_levels a,
109: bsc_sys_dim_levels_vl b
110: where a.tab_id=p_tab_id
111: and a.dim_level_index=p_level_index
112: and a.PARENT_DIM_LEVEL_ID=b.dim_level_id;

Line 463: where exists (select TAB_ID from bsc_sys_com_dim_levels where tab_id=p_tab_id);

459: function has_access_level(p_tab_id in varchar2) return varchar2 is
460: cursor c_exist is
461: select 'Y'
462: from dual
463: where exists (select TAB_ID from bsc_sys_com_dim_levels where tab_id=p_tab_id);
464: l_dummy varchar2(1);
465: begin
466: l_dummy:=null;
467: open c_exist;

Line 560: bsc_sys_com_dim_levels

556: select distinct
557: DIM_LEVEL_INDEX DIM_LEVEL_INDEX,
558: '0' DIM_LEVEL_VALUE ---default value 'ALL'
559: from
560: bsc_sys_com_dim_levels
561: where tab_id=p_tab_id;
562:
563: l_comm_dim_value_rec comm_dim_value%rowtype;
564: