APPS.BSC_UPDATE_UTIL dependencies on BSC_KPI_DATA_TABLES

Line 3223: FROM bsc_kpi_data_tables t, bsc_db_tables_rels r, bsc_kpis_b k

3219: ) RETURN NUMBER IS
3220:
3221: CURSOR c_kpis IS
3222: SELECT DISTINCT k.indicator, k.prototype_flag
3223: FROM bsc_kpi_data_tables t, bsc_db_tables_rels r, bsc_kpis_b k
3224: WHERE t.table_name = r.table_name AND
3225: t.indicator = k.indicator AND
3226: (t.table_name = x_table_name OR
3227: (r.source_table_name = x_table_name AND r.relation_type = 1));

Line 3631: ' FROM bsc_kpi_data_tables t, bsc_kpis_b k'||

3627: /* TYPE t_cursor IS REF CURSOR;
3628:
3629: c_indicator t_cursor; -- x_table_name, 1
3630: c_indicator_sql VARCHAR2(2000) := 'SELECT t.indicator'||
3631: ' FROM bsc_kpi_data_tables t, bsc_kpis_b k'||
3632: ' WHERE t.indicator = k.indicator AND'||
3633: ' table_name = :1 AND NVL(k.edw_flag, 0) = :2';
3634: */
3635: cursor c_indicator (pTableName varchar2, pEDWFlag number ) is

Line 3637: FROM bsc_kpi_data_tables t, bsc_kpis_b k

3633: ' table_name = :1 AND NVL(k.edw_flag, 0) = :2';
3634: */
3635: cursor c_indicator (pTableName varchar2, pEDWFlag number ) is
3636: SELECT t.indicator
3637: FROM bsc_kpi_data_tables t, bsc_kpis_b k
3638: WHERE t.indicator = k.indicator AND
3639: table_name = pTableName AND NVL(k.edw_flag, 0) = pEDWFlag;
3640:
3641: h_indicator NUMBER;

Line 5386: ' FROM bsc_kpi_data_tables'||

5382: ' SET last_updated_by = :1,'||
5383: ' last_update_date = SYSDATE'||
5384: ' WHERE indicator IN ('||
5385: ' SELECT indicator'||
5386: ' FROM bsc_kpi_data_tables'||
5387: ' WHERE table_name = :2)';
5388: EXECUTE IMMEDIATE h_sql USING h_user_id, x_table_name;
5389: */
5390:

Line 5396: FROM bsc_kpi_data_tables

5392: SET last_updated_by = h_user_id,
5393: last_update_date = SYSDATE
5394: WHERE indicator IN (
5395: SELECT indicator
5396: FROM bsc_kpi_data_tables
5397: WHERE table_name = x_table_name);
5398:
5399: --LOCKING: remove this commit
5400: --COMMIT;

Line 6098: from bsc_kpi_data_tables kd, bsc_kpi_properties k

6094: select distinct table_name
6095: from bsc_db_tables_rels
6096: start with table_name in (
6097: select distinct kd.table_name
6098: from bsc_kpi_data_tables kd, bsc_kpi_properties k
6099: where k.indicator = kd.indicator and
6100: k.property_code = h_aw_impl_type_name and
6101: k.property_value = h_aw_kpi_type and
6102: kd.table_name is not null