APPS.BEN_ORG_DELETE dependencies on BEN_LER_CHG_DPNT_CVG_CTFN_F

Line 926: is select 1 from BEN_LER_CHG_DPNT_CVG_CTFN_F

922: is select 1 from BEN_LER_CHG_PTIP_ENRT_F
923: where business_group_id = p_bg_id;
924:
925: cursor c232(p_bg_id NUMBER)
926: is select 1 from BEN_LER_CHG_DPNT_CVG_CTFN_F
927: where business_group_id = p_bg_id;
928:
929: cursor c233(p_bg_id NUMBER)
930: is select 1 from BEN_LER_CHG_OIPL_ENRT_RL_F

Line 4631: -- Testing for values in BEN_LER_CHG_DPNT_CVG_CTFN_F

4627: --
4628: close c231;
4629:
4630: --
4631: -- Testing for values in BEN_LER_CHG_DPNT_CVG_CTFN_F
4632: --
4633: open c232(p_bg_id);
4634: --
4635: fetch c232 into l_temp;

Line 4639: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_DPNT_CVG_CTFN_F');

4635: fetch c232 into l_temp;
4636: if c232%found then
4637: close c232;
4638: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4639: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_DPNT_CVG_CTFN_F');
4640: fnd_message.raise_error;
4641: end if;
4642: --
4643: close c232;

Line 6267: delete from BEN_LER_CHG_DPNT_CVG_CTFN_F

6263:
6264: delete from BEN_LER_CHG_PTIP_ENRT_F
6265: where business_group_id = p_bg_id;
6266:
6267: delete from BEN_LER_CHG_DPNT_CVG_CTFN_F
6268: where business_group_id = p_bg_id;
6269:
6270: delete from BEN_LER_CHG_OIPL_ENRT_RL_F
6271: where business_group_id = p_bg_id;