APPS.BEN_ORG_DELETE dependencies on BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F

Line 766: is select 1 from BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F

762: is select 1 from BEN_CVG_AMT_CALC_MTHD_F
763: where business_group_id = p_bg_id;
764:
765: cursor c192(p_bg_id NUMBER)
766: is select 1 from BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F
767: where business_group_id = p_bg_id;
768:
769: cursor c193(p_bg_id NUMBER)
770: is select 1 from BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F

Line 4031: -- Testing for values in BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F

4027: --
4028: close c191;
4029:
4030: --
4031: -- Testing for values in BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F
4032: --
4033: open c192(p_bg_id);
4034: --
4035: fetch c192 into l_temp;

Line 4039: fnd_message.set_token('TABLE_NAME','BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F');

4035: fetch c192 into l_temp;
4036: if c192%found then
4037: close c192;
4038: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4039: fnd_message.set_token('TABLE_NAME','BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F');
4040: fnd_message.raise_error;
4041: end if;
4042: --
4043: close c192;

Line 6147: delete from BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F

6143:
6144: delete from BEN_CVG_AMT_CALC_MTHD_F
6145: where business_group_id = p_bg_id;
6146:
6147: delete from BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F
6148: where business_group_id = p_bg_id;
6149:
6150: delete from BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F
6151: where business_group_id = p_bg_id;