APPS.BEN_ORG_DELETE dependencies on BEN_BENFTS_GRP_RT_F

Line 806: is select 1 from BEN_BENFTS_GRP_RT_F

802: is select 1 from BEN_ASNT_SET_RT_F
803: where business_group_id = p_bg_id;
804:
805: cursor c202(p_bg_id NUMBER)
806: is select 1 from BEN_BENFTS_GRP_RT_F
807: where business_group_id = p_bg_id;
808:
809: cursor c203(p_bg_id NUMBER)
810: is select 1 from BEN_PRTT_ENRT_RSLT_F

Line 4181: -- Testing for values in BEN_BENFTS_GRP_RT_F

4177: --
4178: close c201;
4179:
4180: --
4181: -- Testing for values in BEN_BENFTS_GRP_RT_F
4182: --
4183: open c202(p_bg_id);
4184: --
4185: fetch c202 into l_temp;

Line 4189: fnd_message.set_token('TABLE_NAME','BEN_BENFTS_GRP_RT_F');

4185: fetch c202 into l_temp;
4186: if c202%found then
4187: close c202;
4188: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4189: fnd_message.set_token('TABLE_NAME','BEN_BENFTS_GRP_RT_F');
4190: fnd_message.raise_error;
4191: end if;
4192: --
4193: close c202;

Line 6177: delete from BEN_BENFTS_GRP_RT_F

6173:
6174: delete from BEN_ASNT_SET_RT_F
6175: where business_group_id = p_bg_id;
6176:
6177: delete from BEN_BENFTS_GRP_RT_F
6178: where business_group_id = p_bg_id;
6179:
6180: delete from BEN_PRTT_ENRT_RSLT_F
6181: where business_group_id = p_bg_id;