APPS.BEN_ORG_DELETE dependencies on BEN_ENRT_ENRLD_ANTHR_OIPL_F

Line 778: is select 1 from BEN_ENRT_ENRLD_ANTHR_OIPL_F

774: is select 1 from BEN_ELIG_PER_F
775: where business_group_id = p_bg_id;
776:
777: cursor c195(p_bg_id NUMBER)
778: is select 1 from BEN_ENRT_ENRLD_ANTHR_OIPL_F
779: where business_group_id = p_bg_id;
780:
781: cursor c196(p_bg_id NUMBER)
782: is select 1 from BEN_LER_CHG_DPNT_CVG_F

Line 4076: -- Testing for values in BEN_ENRT_ENRLD_ANTHR_OIPL_F

4072: --
4073: close c194;
4074:
4075: --
4076: -- Testing for values in BEN_ENRT_ENRLD_ANTHR_OIPL_F
4077: --
4078: open c195(p_bg_id);
4079: --
4080: fetch c195 into l_temp;

Line 4084: fnd_message.set_token('TABLE_NAME','BEN_ENRT_ENRLD_ANTHR_OIPL_F');

4080: fetch c195 into l_temp;
4081: if c195%found then
4082: close c195;
4083: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4084: fnd_message.set_token('TABLE_NAME','BEN_ENRT_ENRLD_ANTHR_OIPL_F');
4085: fnd_message.raise_error;
4086: end if;
4087: --
4088: close c195;

Line 6156: delete from BEN_ENRT_ENRLD_ANTHR_OIPL_F

6152:
6153: delete from BEN_ELIG_PER_F
6154: where business_group_id = p_bg_id;
6155:
6156: delete from BEN_ENRT_ENRLD_ANTHR_OIPL_F
6157: where business_group_id = p_bg_id;
6158:
6159: delete from BEN_LER_CHG_DPNT_CVG_F
6160: where business_group_id = p_bg_id;