APPS.BEN_ORG_DELETE dependencies on BEN_APLD_DPNT_CVG_ELIG_PRFL_F

Line 758: is select 1 from BEN_APLD_DPNT_CVG_ELIG_PRFL_F

754: is select 1 from BEN_LER_BNFT_RSTRN_CTFN_F
755: where business_group_id = p_bg_id;
756:
757: cursor c190(p_bg_id NUMBER)
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

Line 4001: -- Testing for values in BEN_APLD_DPNT_CVG_ELIG_PRFL_F

3997: --
3998: close c189;
3999:
4000: --
4001: -- Testing for values in BEN_APLD_DPNT_CVG_ELIG_PRFL_F
4002: --
4003: open c190(p_bg_id);
4004: --
4005: fetch c190 into l_temp;

Line 4009: fnd_message.set_token('TABLE_NAME','BEN_APLD_DPNT_CVG_ELIG_PRFL_F');

4005: fetch c190 into l_temp;
4006: if c190%found then
4007: close c190;
4008: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4009: fnd_message.set_token('TABLE_NAME','BEN_APLD_DPNT_CVG_ELIG_PRFL_F');
4010: fnd_message.raise_error;
4011: end if;
4012: --
4013: close c190;

Line 6141: delete from BEN_APLD_DPNT_CVG_ELIG_PRFL_F

6137:
6138: delete from BEN_LER_BNFT_RSTRN_CTFN_F
6139: where business_group_id = p_bg_id;
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;