DBA Data[Home] [Help]

APPS.BSC_CAUSE_EFFECT_REL_PVT dependencies on BSC_KPIS_B

Line 49: FROM bsc_kpis_b

45: -- Check that the kpi (if KPI level) or dataset (DATASET level) already exists
46: l_count := 0;
47: IF p_Bsc_Cause_Effect_Rel_Rec.Cause_Level = 'KPI' THEN
48: SELECT count(*) INTO l_count
49: FROM bsc_kpis_b
50: WHERE indicator = p_Bsc_Cause_Effect_Rel_Rec.Cause_Indicator;
51: ELSE
52: SELECT count(*) INTO l_count
53: FROM bsc_sys_datasets_b

Line 65: FROM bsc_kpis_b

61:
62: l_count := 0;
63: IF p_Bsc_Cause_Effect_Rel_Rec.Effect_Level = 'KPI' THEN
64: SELECT count(*) INTO l_count
65: FROM bsc_kpis_b
66: WHERE indicator = p_Bsc_Cause_Effect_Rel_Rec.Effect_Indicator;
67: ELSE
68: SELECT count(*) INTO l_count
69: FROM bsc_sys_datasets_b