APPS.BEN_ORG_DELETE dependencies on BEN_LER_CHG_PTIP_ENRT_F

Line 922: is select 1 from BEN_LER_CHG_PTIP_ENRT_F

918: is select 1 from BEN_ELIG_OTHR_PTIP_PRTE_F
919: where business_group_id = p_bg_id;
920:
921: cursor c231(p_bg_id NUMBER)
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

Line 4616: -- Testing for values in BEN_LER_CHG_PTIP_ENRT_F

4612: --
4613: close c230;
4614:
4615: --
4616: -- Testing for values in BEN_LER_CHG_PTIP_ENRT_F
4617: --
4618: open c231(p_bg_id);
4619: --
4620: fetch c231 into l_temp;

Line 4624: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_PTIP_ENRT_F');

4620: fetch c231 into l_temp;
4621: if c231%found then
4622: close c231;
4623: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4624: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_PTIP_ENRT_F');
4625: fnd_message.raise_error;
4626: end if;
4627: --
4628: close c231;

Line 6264: delete from BEN_LER_CHG_PTIP_ENRT_F

6260:
6261: delete from BEN_ELIG_OTHR_PTIP_PRTE_F
6262: where business_group_id = p_bg_id;
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;