APPS.BSC_MO_HELPER_PKG dependencies on BSC_SYS_DIM_LEVEL_RELS

Line 7133: FROM BSC_SYS_DIM_LEVELS_B D, BSC_SYS_DIM_LEVEL_RELS R

7129:
7130:
7131: cursor C2 (p_dimID IN NUMBER, p_relation_type number)is
7132: SELECT D.LEVEL_TABLE_NAME, D.LEVEL_PK_COL
7133: FROM BSC_SYS_DIM_LEVELS_B D, BSC_SYS_DIM_LEVEL_RELS R
7134: WHERE D.DIM_LEVEL_ID = R.PARENT_DIM_LEVEL_ID
7135: AND R.DIM_LEVEL_ID = p_dimID
7136: AND R.RELATION_TYPE = p_relation_type;
7137:

Line 7152: FROM BSC_SYS_DIM_LEVEL_RELS D, BSC_DB_TABLES_RELS T

7148: cRow3 c3%ROWTYPE;
7149:
7150: cursor c4 is
7151: SELECT DISTINCT D.RELATION_COL, T.SOURCE_TABLE_NAME
7152: FROM BSC_SYS_DIM_LEVEL_RELS D, BSC_DB_TABLES_RELS T
7153: WHERE D.RELATION_TYPE = 2 AND D.RELATION_COL = T.TABLE_NAME (+);
7154:
7155: cRow4 c4%ROWTYPE;
7156:

Line 7163: BSC_SYS_DIM_LEVEL_RELS R,

7159: A.LEVEL_PK_COL AS PK_COL_A,
7160: B.LEVEL_TABLE_NAME AS TABLE_B,
7161: B.LEVEL_PK_COL AS PK_COL_B
7162: FROM BSC_SYS_DIM_LEVELS_B A,
7163: BSC_SYS_DIM_LEVEL_RELS R,
7164: BSC_SYS_DIM_LEVELS_B B
7165: WHERE
7166: A.DIM_LEVEL_ID = R.DIM_LEVEL_ID AND
7167: R.PARENT_DIM_LEVEL_ID = B.DIM_LEVEL_ID AND