APPS.BEN_ORG_DELETE dependencies on BEN_PTIP_DPNT_CVG_CTFN_F

Line 962: is select 1 from BEN_PTIP_DPNT_CVG_CTFN_F

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
963: where business_group_id = p_bg_id;
964:
965: cursor c242(p_bg_id NUMBER)
966: is select 1 from BEN_WV_PRTN_RSN_PTIP_F

Line 4766: -- Testing for values in BEN_PTIP_DPNT_CVG_CTFN_F

4762: --
4763: close c240;
4764:
4765: --
4766: -- Testing for values in BEN_PTIP_DPNT_CVG_CTFN_F
4767: --
4768: open c241(p_bg_id);
4769: --
4770: fetch c241 into l_temp;

Line 4774: fnd_message.set_token('TABLE_NAME','BEN_PTIP_DPNT_CVG_CTFN_F');

4770: fetch c241 into l_temp;
4771: if c241%found then
4772: close c241;
4773: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4774: fnd_message.set_token('TABLE_NAME','BEN_PTIP_DPNT_CVG_CTFN_F');
4775: fnd_message.raise_error;
4776: end if;
4777: --
4778: close c241;

Line 6294: delete from BEN_PTIP_DPNT_CVG_CTFN_F

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;
6296:
6297: delete from BEN_WV_PRTN_RSN_PTIP_F
6298: where business_group_id = p_bg_id;