APPS.BEN_ORG_DELETE dependencies on BEN_ELCTBL_CHC_CTFN

Line 850: is select 1 from BEN_ELCTBL_CHC_CTFN

846: is select 1 from BEN_PRTN_ELIGY_RL_F
847: where business_group_id = p_bg_id;
848:
849: cursor c213(p_bg_id NUMBER)
850: is select 1 from BEN_ELCTBL_CHC_CTFN
851: where business_group_id = p_bg_id;
852:
853: cursor c214(p_bg_id NUMBER)
854: is select 1 from BEN_ACTL_PREM_VRBL_RT_RL_F

Line 4346: -- Testing for values in BEN_ELCTBL_CHC_CTFN

4342: --
4343: close c212;
4344:
4345: --
4346: -- Testing for values in BEN_ELCTBL_CHC_CTFN
4347: --
4348: open c213(p_bg_id);
4349: --
4350: fetch c213 into l_temp;

Line 4354: fnd_message.set_token('TABLE_NAME','BEN_ELCTBL_CHC_CTFN');

4350: fetch c213 into l_temp;
4351: if c213%found then
4352: close c213;
4353: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4354: fnd_message.set_token('TABLE_NAME','BEN_ELCTBL_CHC_CTFN');
4355: fnd_message.raise_error;
4356: end if;
4357: --
4358: close c213;

Line 6210: delete from BEN_ELCTBL_CHC_CTFN

6206:
6207: delete from BEN_PRTN_ELIGY_RL_F
6208: where business_group_id = p_bg_id;
6209:
6210: delete from BEN_ELCTBL_CHC_CTFN
6211: where business_group_id = p_bg_id;
6212:
6213: delete from BEN_ACTL_PREM_VRBL_RT_RL_F
6214: where business_group_id = p_bg_id;