APPS.BEN_EEG_BUS dependencies on BEN_ELIG_ENRLD_ANTHR_PGM_F

Line 59: ben_eeg_shd.constraint_error('BEN_ELIG_ENRLD_ANTHR_PGM_F_PK');

55: <> ben_eeg_shd.g_old_rec.elig_enrld_anthr_pgm_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_eeg_shd.constraint_error('BEN_ELIG_ENRLD_ANTHR_PGM_F_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 69: ben_eeg_shd.constraint_error('BEN_ELIG_ENRLD_ANTHR_PGM_F_PK');

65: if p_elig_enrld_anthr_pgm_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_eeg_shd.constraint_error('BEN_ELIG_ENRLD_ANTHR_PGM_F_PK');
70: --
71: end if;
72: --
73: end if;

Line 129: from ben_elig_enrld_anthr_pgm_f eeg

125: between pgm.effective_start_date and pgm.effective_end_date;
126: --
127: cursor c3 is
128: select null
129: from ben_elig_enrld_anthr_pgm_f eeg
130: where eeg.pgm_id = p_pgm_id
131: and eeg.eligy_prfl_id = p_eligy_prfl_id
132: and eeg.elig_enrld_anthr_pgm_id <> nvl(p_elig_enrld_anthr_pgm_id,hr_api.g_number)
133:

Line 369: from ben_elig_enrld_anthr_pgm_f

365: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
366: l_dummy char(1);
367: cursor c1 is
368: select null
369: from ben_elig_enrld_anthr_pgm_f
370: where elig_enrld_anthr_pgm_id <> nvl(p_elig_enrld_anthr_pgm_id,-1)
371: and eligy_prfl_id = p_eligy_prfl_id
372: and ordr_num = p_ordr_num
373: and business_group_id = p_business_group_id;

Line 762: ben_elig_enrld_anthr_pgm_f b

758: --
759: cursor csr_leg_code is
760: select a.legislation_code
761: from per_business_groups a,
762: ben_elig_enrld_anthr_pgm_f b
763: where b.elig_enrld_anthr_pgm_id = p_elig_enrld_anthr_pgm_id
764: and a.business_group_id = b.business_group_id;
765: --
766: -- Declare local variables