APPS.BEN_ORG_DELETE dependencies on BEN_ACTL_PREM_VRBL_RT_F

Line 874: is select 1 from BEN_ACTL_PREM_VRBL_RT_F

870: is select 1 from BEN_WV_PRTN_RSN_CTFN_PL_F
871: where business_group_id = p_bg_id;
872:
873: cursor c219(p_bg_id NUMBER)
874: is select 1 from BEN_ACTL_PREM_VRBL_RT_F
875: where business_group_id = p_bg_id;
876:
877: cursor c220(p_bg_id NUMBER)
878: is select 1 from BEN_ELIG_PER_OPT_F

Line 4436: -- Testing for values in BEN_ACTL_PREM_VRBL_RT_F

4432: --
4433: close c218;
4434:
4435: --
4436: -- Testing for values in BEN_ACTL_PREM_VRBL_RT_F
4437: --
4438: open c219(p_bg_id);
4439: --
4440: fetch c219 into l_temp;

Line 4444: fnd_message.set_token('TABLE_NAME','BEN_ACTL_PREM_VRBL_RT_F');

4440: fetch c219 into l_temp;
4441: if c219%found then
4442: close c219;
4443: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4444: fnd_message.set_token('TABLE_NAME','BEN_ACTL_PREM_VRBL_RT_F');
4445: fnd_message.raise_error;
4446: end if;
4447: --
4448: close c219;

Line 6228: delete from BEN_ACTL_PREM_VRBL_RT_F

6224:
6225: delete from BEN_WV_PRTN_RSN_CTFN_PL_F
6226: where business_group_id = p_bg_id;
6227:
6228: delete from BEN_ACTL_PREM_VRBL_RT_F
6229: where business_group_id = p_bg_id;
6230:
6231: delete from BEN_ELIG_PER_OPT_F
6232: where business_group_id = p_bg_id;