APPS.BEN_ORG_DELETE dependencies on BEN_BNFT_VRBL_RT_F

Line 814: is select 1 from BEN_BNFT_VRBL_RT_F

810: is select 1 from BEN_PRTT_ENRT_RSLT_F
811: where business_group_id = p_bg_id;
812:
813: cursor c204(p_bg_id NUMBER)
814: is select 1 from BEN_BNFT_VRBL_RT_F
815: where business_group_id = p_bg_id;
816:
817: cursor c205(p_bg_id NUMBER)
818: is select 1 from BEN_ELIG_CVRD_DPNT_F

Line 4211: -- Testing for values in BEN_BNFT_VRBL_RT_F

4207: --
4208: close c203;
4209:
4210: --
4211: -- Testing for values in BEN_BNFT_VRBL_RT_F
4212: --
4213: open c204(p_bg_id);
4214: --
4215: fetch c204 into l_temp;

Line 4219: fnd_message.set_token('TABLE_NAME','BEN_BNFT_VRBL_RT_F');

4215: fetch c204 into l_temp;
4216: if c204%found then
4217: close c204;
4218: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4219: fnd_message.set_token('TABLE_NAME','BEN_BNFT_VRBL_RT_F');
4220: fnd_message.raise_error;
4221: end if;
4222: --
4223: close c204;

Line 6183: delete from BEN_BNFT_VRBL_RT_F

6179:
6180: delete from BEN_PRTT_ENRT_RSLT_F
6181: where business_group_id = p_bg_id;
6182:
6183: delete from BEN_BNFT_VRBL_RT_F
6184: where business_group_id = p_bg_id;
6185:
6186: delete from BEN_ELIG_CVRD_DPNT_F
6187: where business_group_id = p_bg_id;