APPS.BEN_EPM_BUS dependencies on BEN_ENRLD_ANTHR_PGM_RT_F

Line 129: from ben_enrld_anthr_pgm_rt_f epm

125: between pgm.effective_start_date and pgm.effective_end_date;
126: --
127: cursor c3 is
128: select null
129: from ben_enrld_anthr_pgm_rt_f epm
130: where epm.pgm_id = p_pgm_id
131: and epm.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
132: and epm.enrld_anthr_pgm_rt_id <> nvl(p_enrld_anthr_pgm_rt_id,hr_api.g_number)
133:

Line 374: from ben_enrld_anthr_pgm_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_pgm_rt_f
375: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
376: and enrld_anthr_pgm_rt_id <> nvl(p_enrld_anthr_pgm_rt_id ,-1)
377: --and p_effective_date between effective_start_date
378: -- and effective_end_date

Line 782: ben_enrld_anthr_pgm_rt_f b

778: --
779: cursor csr_leg_code is
780: select a.legislation_code
781: from per_business_groups a,
782: ben_enrld_anthr_pgm_rt_f b
783: where b.enrld_anthr_pgm_rt_id = p_enrld_anthr_pgm_rt_id
784: and a.business_group_id = b.business_group_id;
785: --
786: -- Declare local variables