APPS.BSC_UTILITY dependencies on BSC_KPIS_B

Line 1515: FROM BSC_KPIS_B

1511: ) RETURN BOOLEAN IS
1512:
1513: CURSOR c_Production IS
1514: SELECT PROTOTYPE_FLAG
1515: FROM BSC_KPIS_B
1516: WHERE INDICATOR = p_Kpi_Id;
1517:
1518: l_Prototype_Flag NUMBER;
1519: BEGIN

Line 1694: l_Short_Name BSC_KPIS_B.SHORT_NAME%TYPE;

1690: )RETURN NUMBER IS
1691: l_count NUMBER;
1692: l_souce VARCHAR2(100);
1693: l_Flag BOOLEAN := FALSE;
1694: l_Short_Name BSC_KPIS_B.SHORT_NAME%TYPE;
1695: l_Is_EndToEnd_Kpi VARCHAR2(2);
1696:
1697: CURSOR c_source IS
1698: SELECT DISTINCT(sys.source) source

Line 1715: FROM BSC_KPIS_B

1711: EXIT;
1712: ELSIF(c_rec.source = 'PMF') THEN
1713: SELECT short_name
1714: INTO l_Short_Name
1715: FROM BSC_KPIS_B
1716: WHERE indicator= p_Kpi_Id;
1717: l_Is_EndToEnd_Kpi := BSC_BIS_KPI_CRUD_PUB.IS_KPI_ENDTOEND_KPI(l_Short_Name);
1718: IF(l_Is_EndToEnd_Kpi = 'T') THEN
1719: l_Flag := TRUE;

Line 2219: , BSC_KPIS_B K

2215: l_Count NUMBER;
2216: BEGIN
2217: SELECT COUNT(1) INTO l_Count
2218: FROM BSC_SYS_DIM_GROUPS_VL B
2219: , BSC_KPIS_B K
2220: , BSC_KPI_DIM_GROUPS G
2221: WHERE B.SHORT_NAME = p_Short_Name
2222: AND K.SHORT_NAME = B.SHORT_NAME
2223: AND G.INDICATOR = K.INDICATOR;

Line 3760: FROM bsc_kpis_b k, bsc_kpi_analysis_measures_b m

3756: l_obj_count NUMBER;
3757:
3758: CURSOR c_attached_obj IS
3759: SELECT COUNT(1)
3760: FROM bsc_kpis_b k, bsc_kpi_analysis_measures_b m
3761: WHERE k.indicator = m.indicator
3762: AND m.dataset_id = p_dataset_id
3763: AND k.short_name <> p_region_code;
3764:

Line 4028: p_Indicator IN BSC_KPIS_B.indicator%TYPE

4024:
4025:
4026: FUNCTION Is_Report_Primary_Data_Source
4027: (
4028: p_Indicator IN BSC_KPIS_B.indicator%TYPE
4029: ,p_Dataset_Id IN BSC_SYS_DATASETS_B.dataset_id%TYPE
4030: ) RETURN VARCHAR2
4031: IS
4032: l_region_code BSC_KPIS_B.short_name%TYPE;

Line 4032: l_region_code BSC_KPIS_B.short_name%TYPE;

4028: p_Indicator IN BSC_KPIS_B.indicator%TYPE
4029: ,p_Dataset_Id IN BSC_SYS_DATASETS_B.dataset_id%TYPE
4030: ) RETURN VARCHAR2
4031: IS
4032: l_region_code BSC_KPIS_B.short_name%TYPE;
4033: l_meas_short_name BIS_INDICATORS.short_name%TYPE;
4034: l_flag VARCHAR2(10);
4035: BEGIN
4036:

Line 4041: FROM bsc_kpis_b

4037: l_flag := FND_API.G_FALSE;
4038:
4039: SELECT short_name
4040: INTO l_region_code
4041: FROM bsc_kpis_b
4042: WHERE indicator =p_Indicator;
4043:
4044: SELECT short_name
4045: INTO l_meas_short_name