APPS.BSC_UPDATE_DIM dependencies on BSC_SYS_COM_DIM_LEVELS

Line 4819: FROM BSC_SYS_COM_DIM_LEVELS L, BSC_SYS_DIM_LEVELS_B D

4815: l_num_bind_vars NUMBER;
4816:
4817: CURSOR c_list IS
4818: SELECT DISTINCT L.DIM_LEVEL_ID, D.LEVEL_TABLE_NAME
4819: FROM BSC_SYS_COM_DIM_LEVELS L, BSC_SYS_DIM_LEVELS_B D
4820: WHERE L.DIM_LEVEL_ID = D.DIM_LEVEL_ID;
4821:
4822: BEGIN
4823: l_num_bind_vars := 0;

Line 4829: ' FROM BSC_SYS_COM_DIM_LEVELS L, BSC_SYS_DIM_LEVELS_B D'||

4825: -- Get the dimension id and dimension table name for the dimension involved
4826: -- in any list of any tab
4827: /*
4828: h_sql := 'SELECT DISTINCT L.DIM_LEVEL_ID, D.LEVEL_TABLE_NAME'||
4829: ' FROM BSC_SYS_COM_DIM_LEVELS L, BSC_SYS_DIM_LEVELS_B D'||
4830: ' WHERE L.DIM_LEVEL_ID = D.DIM_LEVEL_ID';
4831: */
4832: --OPEN h_cursor FOR h_sql;
4833: OPEN c_list;

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

4845:
4846: h_sql := 'DELETE FROM BSC_USER_LIST_ACCESS'||
4847: ' WHERE (RESPONSIBILITY_ID, TAB_ID) IN ('||
4848: ' SELECT LA.RESPONSIBILITY_ID, LA.TAB_ID'||
4849: ' FROM BSC_SYS_COM_DIM_LEVELS L, BSC_USER_LIST_ACCESS LA'||
4850: ' WHERE L.TAB_ID = LA.TAB_ID'||
4851: ' AND L.DIM_LEVEL_INDEX = LA.DIM_LEVEL_INDEX'||
4852: ' AND L.DIM_LEVEL_ID = :1'||
4853: ' AND LA.DIM_LEVEL_VALUE <> ''0'''||