APPS.BSC_UPDATE_VAL dependencies on BSC_KPI_DATA_TABLES

Line 22: FROM bsc_kpi_data_tables t, bsc_kpi_properties p

18: WHERE table_type = 0
19: )
20: START WITH table_name IN (
21: SELECT table_name
22: FROM bsc_kpi_data_tables t, bsc_kpi_properties p
23: WHERE t.indicator = p.indicator (+) AND
24: t.table_name is not null AND
25: p.property_code (+) = p_db_transform AND
26: nvl(p.property_value,1) <> 0

Line 104: FROM bsc_kpi_data_tables t, bsc_kpi_properties p

100: SELECT source_table_name
101: FROM bsc_db_tables_rels
102: START WITH table_name IN (
103: SELECT table_name
104: FROM bsc_kpi_data_tables t, bsc_kpi_properties p
105: WHERE t.indicator = p.indicator AND
106: t.table_name is not null AND
107: p.property_code = h_db_transform AND
108: p.property_value = 0