APPS.BEN_ORG_DELETE dependencies on BEN_WV_PRTN_RSN_PTIP_F

Line 966: is select 1 from BEN_WV_PRTN_RSN_PTIP_F

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
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

Line 4781: -- Testing for values in BEN_WV_PRTN_RSN_PTIP_F

4777: --
4778: close c241;
4779:
4780: --
4781: -- Testing for values in BEN_WV_PRTN_RSN_PTIP_F
4782: --
4783: open c242(p_bg_id);
4784: --
4785: fetch c242 into l_temp;

Line 4789: fnd_message.set_token('TABLE_NAME','BEN_WV_PRTN_RSN_PTIP_F');

4785: fetch c242 into l_temp;
4786: if c242%found then
4787: close c242;
4788: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4789: fnd_message.set_token('TABLE_NAME','BEN_WV_PRTN_RSN_PTIP_F');
4790: fnd_message.raise_error;
4791: end if;
4792: --
4793: close c242;

Line 6297: delete from BEN_WV_PRTN_RSN_PTIP_F

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;
6299:
6300: delete from BEN_CVRD_DPNT_CTFN_PRVDD_F
6301: where business_group_id = p_bg_id;