APPS.BEN_ORG_DELETE dependencies on BEN_CVRD_DPNT_CTFN_PRVDD_F

Line 970: is select 1 from BEN_CVRD_DPNT_CTFN_PRVDD_F

966: is select 1 from BEN_WV_PRTN_RSN_PTIP_F
967: where business_group_id = p_bg_id;
968:
969: cursor c243(p_bg_id NUMBER)
970: is select 1 from BEN_CVRD_DPNT_CTFN_PRVDD_F
971: where business_group_id = p_bg_id;
972:
973: cursor c244(p_bg_id NUMBER)
974: is select 1 from BEN_PER_CM_USG_F

Line 4796: -- Testing for values in BEN_CVRD_DPNT_CTFN_PRVDD_F

4792: --
4793: close c242;
4794:
4795: --
4796: -- Testing for values in BEN_CVRD_DPNT_CTFN_PRVDD_F
4797: --
4798: open c243(p_bg_id);
4799: --
4800: fetch c243 into l_temp;

Line 4804: fnd_message.set_token('TABLE_NAME','BEN_CVRD_DPNT_CTFN_PRVDD_F');

4800: fetch c243 into l_temp;
4801: if c243%found then
4802: close c243;
4803: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4804: fnd_message.set_token('TABLE_NAME','BEN_CVRD_DPNT_CTFN_PRVDD_F');
4805: fnd_message.raise_error;
4806: end if;
4807: --
4808: close c243;

Line 6300: delete from BEN_CVRD_DPNT_CTFN_PRVDD_F

6296:
6297: delete from BEN_WV_PRTN_RSN_PTIP_F
6298: where business_group_id = p_bg_id;
6299:
6300: delete from BEN_CVRD_DPNT_CTFN_PRVDD_F
6301: where business_group_id = p_bg_id;
6302:
6303: delete from BEN_PER_CM_USG_F
6304: where business_group_id = p_bg_id;