APPS.BSC_UPDATE_CALC dependencies on BSC_DB_MEASURE_COLS_VL

Line 3426: -- SUPPORT_BSC_BIS_MEASURES: Only BSC measures exists in bsc_db_measure_cols_vl and

3422: h_column_type_a VARCHAR2(1);
3423: h_table_name VARCHAR2(30);
3424: h_ret BOOLEAN;
3425:
3426: -- SUPPORT_BSC_BIS_MEASURES: Only BSC measures exists in bsc_db_measure_cols_vl and
3427: -- by design we assumed that BIS measures do not have projection.
3428: -- I have added the condition on source in bsc_db_tables_cols
3429: cursor h_cursor (pTableName varchar2,pProjFlag number,pColCnt number,
3430: pColType varchar2,pProjId number, pProjId2 number, pBSCSource varchar2,

Line 3436: FROM bsc_db_tables_cols tc, bsc_db_measure_cols_vl m

3432: SELECT table_name
3433: FROM bsc_db_tables t
3434: WHERE table_name = pTableName AND project_flag = pProjFlag AND
3435: pColCnt <> (SELECT COUNT(tc.column_name)
3436: FROM bsc_db_tables_cols tc, bsc_db_measure_cols_vl m
3437: WHERE tc.table_name = t.table_name AND
3438: tc.column_type = pColType AND
3439: NVL(tc.source, pBSCSource) = pBSCSource1 AND
3440: tc.column_name = m.measure_col (+) AND