APPS.BEN_ORG_DELETE dependencies on BEN_CVG_AMT_CALC_MTHD_F

Line 762: is select 1 from BEN_CVG_AMT_CALC_MTHD_F

758: is select 1 from BEN_APLD_DPNT_CVG_ELIG_PRFL_F
759: where business_group_id = p_bg_id;
760:
761: cursor c191(p_bg_id NUMBER)
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

Line 4016: -- Testing for values in BEN_CVG_AMT_CALC_MTHD_F

4012: --
4013: close c190;
4014:
4015: --
4016: -- Testing for values in BEN_CVG_AMT_CALC_MTHD_F
4017: --
4018: open c191(p_bg_id);
4019: --
4020: fetch c191 into l_temp;

Line 4024: fnd_message.set_token('TABLE_NAME','BEN_CVG_AMT_CALC_MTHD_F');

4020: fetch c191 into l_temp;
4021: if c191%found then
4022: close c191;
4023: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4024: fnd_message.set_token('TABLE_NAME','BEN_CVG_AMT_CALC_MTHD_F');
4025: fnd_message.raise_error;
4026: end if;
4027: --
4028: close c191;

Line 6144: delete from BEN_CVG_AMT_CALC_MTHD_F

6140:
6141: delete from BEN_APLD_DPNT_CVG_ELIG_PRFL_F
6142: where business_group_id = p_bg_id;
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;