APPS.BSC_UPDATE_UTIL dependencies on BSC_KPI_PROPERTIES

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

Line 6126: from bsc_kpi_properties

6122: ) RETURN NUMBER IS
6123:
6124: CURSOR c_impl_type (p_kpi NUMBER, p_prop_code VARCHAR2) IS
6125: select property_value
6126: from bsc_kpi_properties
6127: where indicator = p_kpi and property_code = p_prop_code;
6128:
6129: h_impl_type NUMBER;
6130: h_impl_type_name VARCHAR2(100);

Line 6162: from bsc_kpis_b k, bsc_kpi_properties p

6158: h_aw_kpi_type := 2;
6159:
6160: select count(k.indicator)
6161: into h_count
6162: from bsc_kpis_b k, bsc_kpi_properties p
6163: where k.indicator = p.indicator and
6164: k.prototype_flag in (0,6,7) and
6165: p.property_code = h_aw_impl_type_name and
6166: p.property_value = h_aw_kpi_type;

Line 6193: from bsc_kpis_vl k, bsc_kpi_properties p

6189: h_aw_impl_type := 2;
6190:
6191: select count(k.calendar_id)
6192: into h_count
6193: from bsc_kpis_vl k, bsc_kpi_properties p
6194: where k.indicator = p.indicator and
6195: k.calendar_id = x_calendar_id and
6196: k.prototype_flag in (0,6,7) and
6197: p.property_code = h_aw_impl_type_name and