APPS.BEN_ORG_DELETE dependencies on BEN_ENRT_BNFT

Line 826: is select 1 from BEN_ENRT_BNFT

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
827: where business_group_id = p_bg_id;
828:
829: cursor c208(p_bg_id NUMBER)
830: is select 1 from BEN_PL_BNF_F

Line 4256: -- Testing for values in BEN_ENRT_BNFT

4252: --
4253: close c206;
4254:
4255: --
4256: -- Testing for values in BEN_ENRT_BNFT
4257: --
4258: open c207(p_bg_id);
4259: --
4260: fetch c207 into l_temp;

Line 4264: fnd_message.set_token('TABLE_NAME','BEN_ENRT_BNFT');

4260: fetch c207 into l_temp;
4261: if c207%found then
4262: close c207;
4263: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4264: fnd_message.set_token('TABLE_NAME','BEN_ENRT_BNFT');
4265: fnd_message.raise_error;
4266: end if;
4267: --
4268: close c207;

Line 6192: delete from BEN_ENRT_BNFT

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;
6194:
6195: delete from BEN_PL_BNF_F
6196: where business_group_id = p_bg_id;