APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_ENRLD_ANTHR_PGM_F

Line 470: is select 1 from BEN_ELIG_ENRLD_ANTHR_PGM_F

466: is select 1 from BEN_PGM_F
467: where business_group_id = p_bg_id;
468:
469: cursor c117(p_bg_id NUMBER)
470: is select 1 from BEN_ELIG_ENRLD_ANTHR_PGM_F
471: where business_group_id = p_bg_id;
472:
473: cursor c118(p_bg_id NUMBER)
474: is select 1 from BEN_ELIG_PRTT_ANTHR_PGM_F

Line 2921: -- Testing for values in BEN_ELIG_ENRLD_ANTHR_PGM_F

2917: --
2918: close c116;
2919:
2920: --
2921: -- Testing for values in BEN_ELIG_ENRLD_ANTHR_PGM_F
2922: --
2923: open c117(p_bg_id);
2924: --
2925: fetch c117 into l_temp;

Line 2929: fnd_message.set_token('TABLE_NAME','BEN_ELIG_ENRLD_ANTHR_PGM_F');

2925: fetch c117 into l_temp;
2926: if c117%found then
2927: close c117;
2928: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2929: fnd_message.set_token('TABLE_NAME','BEN_ELIG_ENRLD_ANTHR_PGM_F');
2930: fnd_message.raise_error;
2931: end if;
2932: --
2933: close c117;

Line 5925: delete from BEN_ELIG_ENRLD_ANTHR_PGM_F

5921:
5922: delete from BEN_PGM_F
5923: where business_group_id = p_bg_id;
5924:
5925: delete from BEN_ELIG_ENRLD_ANTHR_PGM_F
5926: where business_group_id = p_bg_id;
5927:
5928: delete from BEN_ELIG_PRTT_ANTHR_PGM_F
5929: where business_group_id = p_bg_id;