APPS.BEN_ORG_DELETE dependencies on BEN_LER_CHG_DPNT_CVG_F

Line 782: is select 1 from BEN_LER_CHG_DPNT_CVG_F

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
783: where business_group_id = p_bg_id;
784:
785: cursor c197(p_bg_id NUMBER)
786: is select 1 from BEN_LER_CHG_OIPL_ENRT_F

Line 4091: -- Testing for values in BEN_LER_CHG_DPNT_CVG_F

4087: --
4088: close c195;
4089:
4090: --
4091: -- Testing for values in BEN_LER_CHG_DPNT_CVG_F
4092: --
4093: open c196(p_bg_id);
4094: --
4095: fetch c196 into l_temp;

Line 4099: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_DPNT_CVG_F');

4095: fetch c196 into l_temp;
4096: if c196%found then
4097: close c196;
4098: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4099: fnd_message.set_token('TABLE_NAME','BEN_LER_CHG_DPNT_CVG_F');
4100: fnd_message.raise_error;
4101: end if;
4102: --
4103: close c196;

Line 6159: delete from BEN_LER_CHG_DPNT_CVG_F

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;
6161:
6162: delete from BEN_LER_CHG_OIPL_ENRT_F
6163: where business_group_id = p_bg_id;