APPS.BEN_ORG_DELETE dependencies on BEN_ASNT_SET_RT_F

Line 802: is select 1 from BEN_ASNT_SET_RT_F

798: is select 1 from BEN_AGE_RT_F
799: where business_group_id = p_bg_id;
800:
801: cursor c201(p_bg_id NUMBER)
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

Line 4166: -- Testing for values in BEN_ASNT_SET_RT_F

4162: --
4163: close c200;
4164:
4165: --
4166: -- Testing for values in BEN_ASNT_SET_RT_F
4167: --
4168: open c201(p_bg_id);
4169: --
4170: fetch c201 into l_temp;

Line 4174: fnd_message.set_token('TABLE_NAME','BEN_ASNT_SET_RT_F');

4170: fetch c201 into l_temp;
4171: if c201%found then
4172: close c201;
4173: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4174: fnd_message.set_token('TABLE_NAME','BEN_ASNT_SET_RT_F');
4175: fnd_message.raise_error;
4176: end if;
4177: --
4178: close c201;

Line 6174: delete from BEN_ASNT_SET_RT_F

6170:
6171: delete from BEN_AGE_RT_F
6172: where business_group_id = p_bg_id;
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;