APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 822: is select 1 from BEN_ELIG_PER_ELCTBL_CHC

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
823: where business_group_id = p_bg_id;
824:
825: cursor c207(p_bg_id NUMBER)
826: is select 1 from BEN_ENRT_BNFT

Line 4241: -- Testing for values in BEN_ELIG_PER_ELCTBL_CHC

4237: --
4238: close c205;
4239:
4240: --
4241: -- Testing for values in BEN_ELIG_PER_ELCTBL_CHC
4242: --
4243: open c206(p_bg_id);
4244: --
4245: fetch c206 into l_temp;

Line 4249: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PER_ELCTBL_CHC');

4245: fetch c206 into l_temp;
4246: if c206%found then
4247: close c206;
4248: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4249: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PER_ELCTBL_CHC');
4250: fnd_message.raise_error;
4251: end if;
4252: --
4253: close c206;

Line 6189: delete from BEN_ELIG_PER_ELCTBL_CHC

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;
6191:
6192: delete from BEN_ENRT_BNFT
6193: where business_group_id = p_bg_id;