APPS.BEN_ORG_DELETE dependencies on BEN_LBR_MMBR_RT_F

Line 742: is select 1 from BEN_LBR_MMBR_RT_F

738: is select 1 from BEN_HRS_WKD_IN_PERD_RT_F
739: where business_group_id = p_bg_id;
740:
741: cursor c186(p_bg_id NUMBER)
742: is select 1 from BEN_LBR_MMBR_RT_F
743: where business_group_id = p_bg_id;
744:
745: cursor c187(p_bg_id NUMBER)
746: is select 1 from BEN_LER_BNFT_RSTRN_F

Line 3941: -- Testing for values in BEN_LBR_MMBR_RT_F

3937: --
3938: close c185;
3939:
3940: --
3941: -- Testing for values in BEN_LBR_MMBR_RT_F
3942: --
3943: open c186(p_bg_id);
3944: --
3945: fetch c186 into l_temp;

Line 3949: fnd_message.set_token('TABLE_NAME','BEN_LBR_MMBR_RT_F');

3945: fetch c186 into l_temp;
3946: if c186%found then
3947: close c186;
3948: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3949: fnd_message.set_token('TABLE_NAME','BEN_LBR_MMBR_RT_F');
3950: fnd_message.raise_error;
3951: end if;
3952: --
3953: close c186;

Line 6129: delete from BEN_LBR_MMBR_RT_F

6125:
6126: delete from BEN_HRS_WKD_IN_PERD_RT_F
6127: where business_group_id = p_bg_id;
6128:
6129: delete from BEN_LBR_MMBR_RT_F
6130: where business_group_id = p_bg_id;
6131:
6132: delete from BEN_LER_BNFT_RSTRN_F
6133: where business_group_id = p_bg_id;