DBA Data[Home] [Help]

APPS.BSC_CAUSE_EFFECT_REL_PVT dependencies on BSC_SYS_DATASETS_B

Line 53: FROM bsc_sys_datasets_b

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');

Line 69: FROM bsc_sys_datasets_b

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');