APPS.BEN_EEP_BUS dependencies on BEN_ELIG_ENRLD_ANTHR_PL_F

Line 129: from ben_elig_enrld_anthr_pl_f eep

125: between pln.effective_start_date and pln.effective_end_date;
126: --
127: cursor c3 is
128: select null
129: from ben_elig_enrld_anthr_pl_f eep
130: where eep.pl_id = p_pl_id
131: and eep.eligy_prfl_id = p_eligy_prfl_id
132: and eep.elig_enrld_anthr_pl_id <> nvl(p_elig_enrld_anthr_pl_id,hr_api.g_number)
133:

Line 369: from ben_elig_enrld_anthr_pl_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_pl_f
370: where elig_enrld_anthr_pl_id <> nvl(p_elig_enrld_anthr_pl_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_pl_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_pl_f b
763: where b.elig_enrld_anthr_pl_id = p_elig_enrld_anthr_pl_id
764: and a.business_group_id = b.business_group_id;
765: --
766: -- Declare local variables