APPS.BSC_DIMENSION_EDIT dependencies on BSC_SYS_COM_DIM_LEVELS

Line 29: FROM BSC_SYS_COM_DIM_LEVELS L, BSC_SYS_DIM_LEVELS_B D

25: h_num_installed_languages NUMBER;
26:
27: CURSOR LEVEL is
28: SELECT DISTINCT L.DIM_LEVEL_ID, D.LEVEL_TABLE_NAME
29: FROM BSC_SYS_COM_DIM_LEVELS L, BSC_SYS_DIM_LEVELS_B D
30: WHERE L.DIM_LEVEL_ID = D.DIM_LEVEL_ID;
31:
32: CURSOR CHILD (l_table_name varchar2) is
33: SELECT T.LEVEL_TABLE_NAME AS CHILDTABLE , P.level_pk_col

Line 58: ' FROM BSC_SYS_COM_DIM_LEVELS L, BSC_USER_LIST_ACCESS LA '||

54: exit when LEVEL%notfound;
55: l_stmt:='DELETE FROM BSC_USER_LIST_ACCESS '||
56: ' WHERE (RESPONSIBILITY_ID, TAB_ID) IN '||
57: '( SELECT LA.RESPONSIBILITY_ID, LA.TAB_ID '||
58: ' FROM BSC_SYS_COM_DIM_LEVELS L, BSC_USER_LIST_ACCESS LA '||
59: ' WHERE L.TAB_ID = LA.TAB_ID '||
60: ' AND L.DIM_LEVEL_INDEX = LA.DIM_LEVEL_INDEX '||
61: ' AND L.DIM_LEVEL_ID = :1 '||
62: ' AND LA.DIM_LEVEL_VALUE <> 0 '||