APPS.BEN_ORG_DELETE dependencies on BEN_WK_LOC_RT_F

Line 710: is select 1 from BEN_WK_LOC_RT_F

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
711: where business_group_id = p_bg_id;
712:
713: cursor c179(p_bg_id NUMBER)
714: is select 1 from BEN_ACTL_PREM_F

Line 3821: -- Testing for values in BEN_WK_LOC_RT_F

3817: --
3818: close c177;
3819:
3820: --
3821: -- Testing for values in BEN_WK_LOC_RT_F
3822: --
3823: open c178(p_bg_id);
3824: --
3825: fetch c178 into l_temp;

Line 3829: fnd_message.set_token('TABLE_NAME','BEN_WK_LOC_RT_F');

3825: fetch c178 into l_temp;
3826: if c178%found then
3827: close c178;
3828: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3829: fnd_message.set_token('TABLE_NAME','BEN_WK_LOC_RT_F');
3830: fnd_message.raise_error;
3831: end if;
3832: --
3833: close c178;

Line 6105: delete from BEN_WK_LOC_RT_F

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;
6107:
6108: delete from BEN_ACTL_PREM_F
6109: where business_group_id = p_bg_id;