APPS.BEN_ORG_DELETE dependencies on BEN_PL_BNF_CTFN_PRVDD_F

Line 958: is select 1 from BEN_PL_BNF_CTFN_PRVDD_F

954: is select 1 from BEN_PER_CM_TRGR_F
955: where business_group_id = p_bg_id;
956:
957: cursor c240(p_bg_id NUMBER)
958: is select 1 from BEN_PL_BNF_CTFN_PRVDD_F
959: where business_group_id = p_bg_id;
960:
961: cursor c241(p_bg_id NUMBER)
962: is select 1 from BEN_PTIP_DPNT_CVG_CTFN_F

Line 4751: -- Testing for values in BEN_PL_BNF_CTFN_PRVDD_F

4747: --
4748: close c239;
4749:
4750: --
4751: -- Testing for values in BEN_PL_BNF_CTFN_PRVDD_F
4752: --
4753: open c240(p_bg_id);
4754: --
4755: fetch c240 into l_temp;

Line 4759: fnd_message.set_token('TABLE_NAME','BEN_PL_BNF_CTFN_PRVDD_F');

4755: fetch c240 into l_temp;
4756: if c240%found then
4757: close c240;
4758: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4759: fnd_message.set_token('TABLE_NAME','BEN_PL_BNF_CTFN_PRVDD_F');
4760: fnd_message.raise_error;
4761: end if;
4762: --
4763: close c240;

Line 6291: delete from BEN_PL_BNF_CTFN_PRVDD_F

6287:
6288: delete from BEN_PER_CM_TRGR_F
6289: where business_group_id = p_bg_id;
6290:
6291: delete from BEN_PL_BNF_CTFN_PRVDD_F
6292: where business_group_id = p_bg_id;
6293:
6294: delete from BEN_PTIP_DPNT_CVG_CTFN_F
6295: where business_group_id = p_bg_id;