APPS.BEN_ORG_DELETE dependencies on BEN_VRBL_RT_PRFL_RL_F

Line 706: is select 1 from BEN_VRBL_RT_PRFL_RL_F

702: is select 1 from BEN_VRBL_MTCHG_RT_F
703: where business_group_id = p_bg_id;
704:
705: cursor c177(p_bg_id NUMBER)
706: is select 1 from BEN_VRBL_RT_PRFL_RL_F
707: where business_group_id = p_bg_id;
708:
709: cursor c178(p_bg_id NUMBER)
710: is select 1 from BEN_WK_LOC_RT_F

Line 3806: -- Testing for values in BEN_VRBL_RT_PRFL_RL_F

3802: --
3803: close c176;
3804:
3805: --
3806: -- Testing for values in BEN_VRBL_RT_PRFL_RL_F
3807: --
3808: open c177(p_bg_id);
3809: --
3810: fetch c177 into l_temp;

Line 3814: fnd_message.set_token('TABLE_NAME','BEN_VRBL_RT_PRFL_RL_F');

3810: fetch c177 into l_temp;
3811: if c177%found then
3812: close c177;
3813: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3814: fnd_message.set_token('TABLE_NAME','BEN_VRBL_RT_PRFL_RL_F');
3815: fnd_message.raise_error;
3816: end if;
3817: --
3818: close c177;

Line 6102: delete from BEN_VRBL_RT_PRFL_RL_F

6098:
6099: delete from BEN_VRBL_MTCHG_RT_F
6100: where business_group_id = p_bg_id;
6101:
6102: delete from BEN_VRBL_RT_PRFL_RL_F
6103: where business_group_id = p_bg_id;
6104:
6105: delete from BEN_WK_LOC_RT_F
6106: where business_group_id = p_bg_id;