DBA Data[Home] [Help]

APPS.BSC_COPY_INDICATOR_PUB dependencies on BSC_KPI_PROPERTIES

Line 1497: bsc_kpi_properties

1493: COUNT(1)
1494: INTO
1495: l_Count
1496: FROM
1497: bsc_kpi_properties
1498: WHERE
1499: indicator = p_Target_Indicator AND
1500: UPPER(property_code) = p_Property_code ;
1501:

Line 1503: INSERT INTO bsc_kpi_properties (

1499: indicator = p_Target_Indicator AND
1500: UPPER(property_code) = p_Property_code ;
1501:
1502: IF l_Count = 0 THEN
1503: INSERT INTO bsc_kpi_properties (
1504: indicator
1505: ,property_code
1506: ,property_value)
1507: VALUES

Line 1513: bsc_kpi_properties

1509: ,p_Property_code
1510: ,p_Property_value);
1511: ELSE
1512: UPDATE
1513: bsc_kpi_properties
1514: SET
1515: property_value = p_Property_value
1516: WHERE
1517: indicator = p_Target_Indicator AND