APPS.BEN_ORG_DELETE dependencies on BEN_PL_BNF_F

Line 830: is select 1 from BEN_PL_BNF_F

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
831: where business_group_id = p_bg_id;
832:
833: cursor c209(p_bg_id NUMBER)
834: is select 1 from BEN_PL_R_OIPL_PREM_BY_MO_F

Line 4271: -- Testing for values in BEN_PL_BNF_F

4267: --
4268: close c207;
4269:
4270: --
4271: -- Testing for values in BEN_PL_BNF_F
4272: --
4273: open c208(p_bg_id);
4274: --
4275: fetch c208 into l_temp;

Line 4279: fnd_message.set_token('TABLE_NAME','BEN_PL_BNF_F');

4275: fetch c208 into l_temp;
4276: if c208%found then
4277: close c208;
4278: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4279: fnd_message.set_token('TABLE_NAME','BEN_PL_BNF_F');
4280: fnd_message.raise_error;
4281: end if;
4282: --
4283: close c208;

Line 6195: delete from BEN_PL_BNF_F

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;
6197:
6198: delete from BEN_PL_R_OIPL_PREM_BY_MO_F
6199: where business_group_id = p_bg_id;

Line 6498: delete from BEN_PL_BNF_F

6494:
6495: delete from BEN_ACTL_PREM_F
6496: where organization_id = p_org_id;
6497:
6498: delete from BEN_PL_BNF_F
6499: where organization_id = p_org_id;
6500:
6501: delete from BEN_BENEFIT_ACTIONS
6502: where organization_id = p_org_id;