APPS.BEN_ORG_DELETE dependencies on BEN_LER_BNFT_RSTRN_F

Line 746: is select 1 from BEN_LER_BNFT_RSTRN_F

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
747: where business_group_id = p_bg_id;
748:
749: cursor c188(p_bg_id NUMBER)
750: is select 1 from BEN_LER_RQRS_ENRT_CTFN_F

Line 3956: -- Testing for values in BEN_LER_BNFT_RSTRN_F

3952: --
3953: close c186;
3954:
3955: --
3956: -- Testing for values in BEN_LER_BNFT_RSTRN_F
3957: --
3958: open c187(p_bg_id);
3959: --
3960: fetch c187 into l_temp;

Line 3964: fnd_message.set_token('TABLE_NAME','BEN_LER_BNFT_RSTRN_F');

3960: fetch c187 into l_temp;
3961: if c187%found then
3962: close c187;
3963: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3964: fnd_message.set_token('TABLE_NAME','BEN_LER_BNFT_RSTRN_F');
3965: fnd_message.raise_error;
3966: end if;
3967: --
3968: close c187;

Line 6132: delete from BEN_LER_BNFT_RSTRN_F

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;
6134:
6135: delete from BEN_LER_RQRS_ENRT_CTFN_F
6136: where business_group_id = p_bg_id;