APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_LER_F

Line 5909: ben_ler_f ler

5905: p_effective_start_date date) is
5906: select null
5907: from ben_prtt_enrt_rslt_f pen,
5908: ben_per_in_ler pil,
5909: ben_ler_f ler
5910: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5911: and pen.effective_start_date > p_effective_start_date
5912: and pen.per_in_ler_id = pil.per_in_ler_id
5913: and pil.ler_id = ler.ler_id

Line 6886: from ben_ler_f ler,

6882: --
6883: -- Bug 2689915
6884: cursor c_ler is
6885: select typ_cd
6886: from ben_ler_f ler,
6887: ben_prtt_enrt_rslt_f pen
6888: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6889: and pen.ler_id = ler.ler_id ;
6890: --

Line 6917: ben_ler_f ler,

6913:
6914: cursor c_crntly_enrd_flag(p_elig_pe_elctbl_chc_id number) is
6915: select epe.crntly_enrd_flag,ler.typ_cd
6916: from ben_elig_per_elctbl_chc epe,
6917: ben_ler_f ler,
6918: ben_prtt_enrt_rslt_f pen
6919: where epe.per_in_ler_id=p_per_in_ler_id
6920: and epe.elig_per_elctbl_chc_id=p_elig_pe_elctbl_chc_id
6921: and epe.prtt_enrt_rslt_id=pen.prtt_enrt_rslt_id

Line 6935: ben_ler_f ler

6931: cursor c_crntly_enrd_flag_unres(p_elig_pe_elctbl_chc_id number) is
6932: select ler.typ_cd
6933: from ben_prtt_enrt_rslt_f pen,
6934: ben_elig_per_elctbl_chc epe,
6935: ben_ler_f ler
6936: where epe.elig_per_elctbl_chc_id=p_elig_pe_elctbl_chc_id
6937: and epe.per_in_ler_id=p_per_in_ler_id
6938: and pen.ler_id = ler.ler_id
6939: and epe.prtt_enrt_rslt_id=pen.prtt_enrt_rslt_id

Line 11729: FROM ben_ler_f ler,

11725: oipl.effective_start_date(+) and oipl.effective_end_date(+)
11726: -- BUG: 3904792: MAINLINE FIX FOR 3894240: WHEN UPDATING A SAVINGS PLAN RATE SYSTEM IS END DATE
11727: AND NOT EXISTS
11728: (SELECT NULL
11729: FROM ben_ler_f ler,
11730: ben_pl_f pln
11731: WHERE ler.ler_id = r.ler_id
11732: AND ler.typ_cd = 'SCHEDDU'
11733: AND pln.SVGS_PL_FLAG = 'Y'

Line 11946: ben_ler_f ler

11942: cursor c_ler_typ_cd is
11943: --
11944: select ler.typ_cd
11945: from ben_per_in_ler pil,
11946: ben_ler_f ler
11947: where pil.per_in_ler_id = p_per_in_ler_id
11948: and pil.ler_id = ler.ler_id
11949: and pil.business_group_id = p_business_group_id
11950: and pil.business_group_id = ler.business_group_id

Line 11954: l_ler_typ_cd ben_ler_f.typ_cd%type;

11950: and pil.business_group_id = ler.business_group_id
11951: and p_effective_date between
11952: ler.effective_start_date and ler.effective_end_date;
11953: --
11954: l_ler_typ_cd ben_ler_f.typ_cd%type;
11955: --
11956: begin
11957: --
11958: g_debug := hr_utility.debug_enabled;