APPS.BEN_ORG_DELETE dependencies on BEN_ACTL_PREM_VRBL_RT_RL_F

Line 854: is select 1 from BEN_ACTL_PREM_VRBL_RT_RL_F

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
855: where business_group_id = p_bg_id;
856:
857: cursor c215(p_bg_id NUMBER)
858: is select 1 from BEN_BNFT_VRBL_RT_RL_F

Line 4361: -- Testing for values in BEN_ACTL_PREM_VRBL_RT_RL_F

4357: --
4358: close c213;
4359:
4360: --
4361: -- Testing for values in BEN_ACTL_PREM_VRBL_RT_RL_F
4362: --
4363: open c214(p_bg_id);
4364: --
4365: fetch c214 into l_temp;

Line 4369: fnd_message.set_token('TABLE_NAME','BEN_ACTL_PREM_VRBL_RT_RL_F');

4365: fetch c214 into l_temp;
4366: if c214%found then
4367: close c214;
4368: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4369: fnd_message.set_token('TABLE_NAME','BEN_ACTL_PREM_VRBL_RT_RL_F');
4370: fnd_message.raise_error;
4371: end if;
4372: --
4373: close c214;

Line 6213: delete from BEN_ACTL_PREM_VRBL_RT_RL_F

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;
6215:
6216: delete from BEN_BNFT_VRBL_RT_RL_F
6217: where business_group_id = p_bg_id;