APPS.BSC_DIMENSION_EDIT dependencies on BSC_SYS_DIM_LEVELS_B

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 34: FROM BSC_SYS_DIM_LEVELS_B T, BSC_SYS_DIM_LEVEL_RELS R, BSC_SYS_DIM_LEVELS_B P

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
34: FROM BSC_SYS_DIM_LEVELS_B T, BSC_SYS_DIM_LEVEL_RELS R, BSC_SYS_DIM_LEVELS_B P
35: WHERE T.DIM_LEVEL_ID = R.DIM_LEVEL_ID
36: and R.PARENT_DIM_LEVEL_ID =P.dim_level_id
37: AND R.RELATION_TYPE = 1
38: and P.level_table_name=l_table_name;

Line 724: l_stmt:='SELECT count(*) FROM BSC_SYS_DIM_LEVELS_B T, BSC_SYS_DIM_LEVEL_RELS R, BSC_SYS_DIM_LEVELS_B P WHERE T.DIM_LEVEL_ID = R.DIM_LEVEL_ID and R.PARENT_DIM_LEVEL_ID =P.dim_level_id AND R.RELATION_TYPE = 1 and P.level_table_name=:1';

720: cv curtyp;
721: l_stmt varchar2(1500);
722: l_count number;
723: begin
724: l_stmt:='SELECT count(*) FROM BSC_SYS_DIM_LEVELS_B T, BSC_SYS_DIM_LEVEL_RELS R, BSC_SYS_DIM_LEVELS_B P WHERE T.DIM_LEVEL_ID = R.DIM_LEVEL_ID and R.PARENT_DIM_LEVEL_ID =P.dim_level_id AND R.RELATION_TYPE = 1 and P.level_table_name=:1';
725: open cv for l_stmt using l_dim_table;
726: fetch cv into l_count;
727: close cv;
728: return l_count;