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
54: WHERE dataset_id = p_Bsc_Cause_Effect_Rel_Rec.Cause_Indicator;
55: END IF;
56: IF l_count = 0 THEN
57: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_CAUSE_INDICATOR');
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
70: WHERE dataset_id = p_Bsc_Cause_Effect_Rel_Rec.Effect_Indicator;
71: END IF;
72: IF l_count = 0 THEN
73: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_EFFECT_INDICATOR');