APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_DPNT_CVRD_OTHR_PL_F

Line 494: is select 1 from BEN_ELIG_DPNT_CVRD_OTHR_PL_F

490: is select 1 from BEN_DPNT_CVRD_ANTHR_PL_CVG_F
491: where business_group_id = p_bg_id;
492:
493: cursor c124(p_bg_id NUMBER)
494: is select 1 from BEN_ELIG_DPNT_CVRD_OTHR_PL_F
495: where business_group_id = p_bg_id;
496:
497: cursor c125(p_bg_id NUMBER)
498: is select 1 from BEN_ELIG_ENRLD_ANTHR_PL_F

Line 3011: -- Testing for values in BEN_ELIG_DPNT_CVRD_OTHR_PL_F

3007: --
3008: close c122;
3009:
3010: --
3011: -- Testing for values in BEN_ELIG_DPNT_CVRD_OTHR_PL_F
3012: --
3013: open c124(p_bg_id);
3014: --
3015: fetch c124 into l_temp;

Line 3019: fnd_message.set_token('TABLE_NAME','BEN_ELIG_DPNT_CVRD_OTHR_PL_F');

3015: fetch c124 into l_temp;
3016: if c124%found then
3017: close c124;
3018: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3019: fnd_message.set_token('TABLE_NAME','BEN_ELIG_DPNT_CVRD_OTHR_PL_F');
3020: fnd_message.raise_error;
3021: end if;
3022: --
3023: close c124;

Line 5943: delete from BEN_ELIG_DPNT_CVRD_OTHR_PL_F

5939:
5940: delete from BEN_DPNT_CVRD_ANTHR_PL_CVG_F
5941: where business_group_id = p_bg_id;
5942:
5943: delete from BEN_ELIG_DPNT_CVRD_OTHR_PL_F
5944: where business_group_id = p_bg_id;
5945:
5946: delete from BEN_ELIG_ENRLD_ANTHR_PL_F
5947: where business_group_id = p_bg_id;