APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_LER_F

Line 5620: ben_ler_f ler

5616: p_effective_start_date date) is
5617: select null
5618: from ben_prtt_enrt_rslt_f pen,
5619: ben_per_in_ler pil,
5620: ben_ler_f ler
5621: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5622: and pen.effective_start_date > p_effective_start_date
5623: and pen.per_in_ler_id = pil.per_in_ler_id
5624: and pil.ler_id = ler.ler_id

Line 6574: from ben_ler_f ler,

6570: --
6571: -- Bug 2689915
6572: cursor c_ler is
6573: select typ_cd
6574: from ben_ler_f ler,
6575: ben_prtt_enrt_rslt_f pen
6576: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6577: and pen.ler_id = ler.ler_id ;
6578: --

Line 6605: ben_ler_f ler,

6601:
6602: cursor c_crntly_enrd_flag(p_elig_pe_elctbl_chc_id number) is
6603: select epe.crntly_enrd_flag,ler.typ_cd
6604: from ben_elig_per_elctbl_chc epe,
6605: ben_ler_f ler,
6606: ben_prtt_enrt_rslt_f pen
6607: where epe.per_in_ler_id=p_per_in_ler_id
6608: and epe.elig_per_elctbl_chc_id=p_elig_pe_elctbl_chc_id
6609: and epe.prtt_enrt_rslt_id=pen.prtt_enrt_rslt_id

Line 6623: ben_ler_f ler

6619: cursor c_crntly_enrd_flag_unres(p_elig_pe_elctbl_chc_id number) is
6620: select ler.typ_cd
6621: from ben_prtt_enrt_rslt_f pen,
6622: ben_elig_per_elctbl_chc epe,
6623: ben_ler_f ler
6624: where epe.elig_per_elctbl_chc_id=p_elig_pe_elctbl_chc_id
6625: and epe.per_in_ler_id=p_per_in_ler_id
6626: and pen.ler_id = ler.ler_id
6627: and epe.prtt_enrt_rslt_id=pen.prtt_enrt_rslt_id

Line 10131: FROM ben_ler_f ler,

10127: oipl.effective_start_date(+) and oipl.effective_end_date(+)
10128: -- BUG: 3904792: MAINLINE FIX FOR 3894240: WHEN UPDATING A SAVINGS PLAN RATE SYSTEM IS END DATE
10129: AND NOT EXISTS
10130: (SELECT NULL
10131: FROM ben_ler_f ler,
10132: ben_pl_f pln
10133: WHERE ler.ler_id = r.ler_id
10134: AND ler.typ_cd = 'SCHEDDU'
10135: AND pln.SVGS_PL_FLAG = 'Y'

Line 10348: ben_ler_f ler

10344: cursor c_ler_typ_cd is
10345: --
10346: select ler.typ_cd
10347: from ben_per_in_ler pil,
10348: ben_ler_f ler
10349: where pil.per_in_ler_id = p_per_in_ler_id
10350: and pil.ler_id = ler.ler_id
10351: and pil.business_group_id = p_business_group_id
10352: and pil.business_group_id = ler.business_group_id

Line 10356: l_ler_typ_cd ben_ler_f.typ_cd%type;

10352: and pil.business_group_id = ler.business_group_id
10353: and p_effective_date between
10354: ler.effective_start_date and ler.effective_end_date;
10355: --
10356: l_ler_typ_cd ben_ler_f.typ_cd%type;
10357: --
10358: begin
10359: --
10360: g_debug := hr_utility.debug_enabled;