APPS.BEN_EAO_BUS dependencies on BEN_ENRLD_ANTHR_OIPL_RT_F

Line 129: from ben_enrld_anthr_oipl_rt_f eao

125: between cop.effective_start_date and cop.effective_end_date;
126: --
127: cursor c3 is
128: select null
129: from ben_enrld_anthr_oipl_rt_f eao
130: where eao.oipl_id = p_oipl_id
131: and eao.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
132: and eao.enrld_anthr_oipl_rt_id <> nvl(p_enrld_anthr_oipl_rt_id,hr_api.g_number)
133:

Line 374: from ben_enrld_anthr_oipl_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_oipl_rt_f
375: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
376: -- changed against bug: 5113011
377: and enrld_anthr_oipl_rt_id <> nvl(p_enrld_anthr_oipl_rt_id ,-1)
378: -- and oipl_id <> nvl(p_oipl_id ,-1)

Line 783: ben_enrld_anthr_oipl_rt_f b

779: --
780: cursor csr_leg_code is
781: select a.legislation_code
782: from per_business_groups a,
783: ben_enrld_anthr_oipl_rt_f b
784: where b.enrld_anthr_oipl_rt_id = p_enrld_anthr_oipl_rt_id
785: and a.business_group_id = b.business_group_id;
786: --
787: -- Declare local variables