APPS.BEN_ORG_DELETE dependencies on BEN_PRTN_ELIGY_RL_F

Line 846: is select 1 from BEN_PRTN_ELIGY_RL_F

842: is select 1 from BEN_ENRT_PREM
843: where business_group_id = p_bg_id;
844:
845: cursor c212(p_bg_id NUMBER)
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

Line 4331: -- Testing for values in BEN_PRTN_ELIGY_RL_F

4327: --
4328: close c211;
4329:
4330: --
4331: -- Testing for values in BEN_PRTN_ELIGY_RL_F
4332: --
4333: open c212(p_bg_id);
4334: --
4335: fetch c212 into l_temp;

Line 4339: fnd_message.set_token('TABLE_NAME','BEN_PRTN_ELIGY_RL_F');

4335: fetch c212 into l_temp;
4336: if c212%found then
4337: close c212;
4338: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4339: fnd_message.set_token('TABLE_NAME','BEN_PRTN_ELIGY_RL_F');
4340: fnd_message.raise_error;
4341: end if;
4342: --
4343: close c212;

Line 6207: delete from BEN_PRTN_ELIGY_RL_F

6203:
6204: delete from BEN_ENRT_PREM
6205: where business_group_id = p_bg_id;
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;