APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_PRTT_ANTHR_PGM_F

Line 474: is select 1 from BEN_ELIG_PRTT_ANTHR_PGM_F

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
475: where business_group_id = p_bg_id;
476:
477: cursor c119(p_bg_id NUMBER)
478: is select 1 from BEN_PLIP_F

Line 2936: -- Testing for values in BEN_ELIG_PRTT_ANTHR_PGM_F

2932: --
2933: close c117;
2934:
2935: --
2936: -- Testing for values in BEN_ELIG_PRTT_ANTHR_PGM_F
2937: --
2938: open c118(p_bg_id);
2939: --
2940: fetch c118 into l_temp;

Line 2944: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PRTT_ANTHR_PGM_F');

2940: fetch c118 into l_temp;
2941: if c118%found then
2942: close c118;
2943: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2944: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PRTT_ANTHR_PGM_F');
2945: fnd_message.raise_error;
2946: end if;
2947: --
2948: close c118;

Line 5928: delete from BEN_ELIG_PRTT_ANTHR_PGM_F

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;
5930:
5931: delete from BEN_PLIP_F
5932: where business_group_id = p_bg_id;