APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_ENRLD_ANTHR_PL_F

Line 498: is select 1 from BEN_ELIG_ENRLD_ANTHR_PL_F

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
499: where business_group_id = p_bg_id;
500:
501: cursor c126(p_bg_id NUMBER)
502: is select 1 from BEN_ENRT_ENRLD_ANTHR_PL_F

Line 3026: -- Testing for values in BEN_ELIG_ENRLD_ANTHR_PL_F

3022: --
3023: close c124;
3024:
3025: --
3026: -- Testing for values in BEN_ELIG_ENRLD_ANTHR_PL_F
3027: --
3028: open c125(p_bg_id);
3029: --
3030: fetch c125 into l_temp;

Line 3034: fnd_message.set_token('TABLE_NAME','BEN_ELIG_ENRLD_ANTHR_PL_F');

3030: fetch c125 into l_temp;
3031: if c125%found then
3032: close c125;
3033: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3034: fnd_message.set_token('TABLE_NAME','BEN_ELIG_ENRLD_ANTHR_PL_F');
3035: fnd_message.raise_error;
3036: end if;
3037: --
3038: close c125;

Line 5946: delete from BEN_ELIG_ENRLD_ANTHR_PL_F

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;
5948:
5949: delete from BEN_ENRT_ENRLD_ANTHR_PL_F
5950: where business_group_id = p_bg_id;