APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_CVRD_DPNT_F

Line 818: is select 1 from BEN_ELIG_CVRD_DPNT_F

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
819: where business_group_id = p_bg_id;
820:
821: cursor c206(p_bg_id NUMBER)
822: is select 1 from BEN_ELIG_PER_ELCTBL_CHC

Line 4226: -- Testing for values in BEN_ELIG_CVRD_DPNT_F

4222: --
4223: close c204;
4224:
4225: --
4226: -- Testing for values in BEN_ELIG_CVRD_DPNT_F
4227: --
4228: open c205(p_bg_id);
4229: --
4230: fetch c205 into l_temp;

Line 4234: fnd_message.set_token('TABLE_NAME','BEN_ELIG_CVRD_DPNT_F');

4230: fetch c205 into l_temp;
4231: if c205%found then
4232: close c205;
4233: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4234: fnd_message.set_token('TABLE_NAME','BEN_ELIG_CVRD_DPNT_F');
4235: fnd_message.raise_error;
4236: end if;
4237: --
4238: close c205;

Line 6186: delete from BEN_ELIG_CVRD_DPNT_F

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;
6188:
6189: delete from BEN_ELIG_PER_ELCTBL_CHC
6190: where business_group_id = p_bg_id;