APPS.BEN_ENL_BUS dependencies on BEN_ENRLD_ANTHR_PL_RT_F

Line 129: from ben_enrld_anthr_pl_rt_f enl

125: between pln.effective_start_date and pln.effective_end_date;
126: --
127: cursor c3 is
128: select null
129: from ben_enrld_anthr_pl_rt_f enl
130: where enl.pl_id = p_pl_id
131: and enl.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
132: and enl.enrld_anthr_pl_rt_id <> nvl(p_enrld_anthr_pl_rt_id,hr_api.g_number)
133:

Line 374: from ben_enrld_anthr_pl_rt_f

370: is
371: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
372: l_dummy char(1);
373: cursor c1 is select null
374: from ben_enrld_anthr_pl_rt_f
375: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
376: -- changed against bug: 5113011
377: and enrld_anthr_pl_rt_id <> nvl(p_enrld_anthr_pl_rt_id ,-1)
378: -- and pl_id <> nvl(p_pl_id ,-1)

Line 784: ben_enrld_anthr_pl_rt_f b

780: --
781: cursor csr_leg_code is
782: select a.legislation_code
783: from per_business_groups a,
784: ben_enrld_anthr_pl_rt_f b
785: where b.enrld_anthr_pl_rt_id = p_enrld_anthr_pl_rt_id
786: and a.business_group_id = b.business_group_id;
787: --
788: -- Declare local variables