APPS.BEN_DETERMINE_RATES dependencies on BEN_PER_IN_LER

Line 271: FROM ben_per_in_ler pil,

267: -- CWB Chnages and GSP changes:
268: --
269: CURSOR c_per_in_ler IS
270: SELECT pil.per_in_ler_id
271: FROM ben_per_in_ler pil,
272: ben_ler_f ler
273: WHERE pil.person_id = p_person_id
274: and pil.ler_id = ler.ler_id
275: and ler.typ_cd not in ('COMP','GSP', 'IREC', 'ABS')

Line 279: FROM ben_per_in_ler b,

275: and ler.typ_cd not in ('COMP','GSP', 'IREC', 'ABS')
276: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
277: AND lf_evt_ocrd_dt =
278: (SELECT MAX(b.lf_evt_ocrd_dt)
279: FROM ben_per_in_ler b,
280: ben_ler_f ler1
281: WHERE b.person_id = p_person_id
282: and b.ler_id = ler1.ler_id
283: and b.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')

Line 1801: ben_per_in_ler pil

1797: pil.person_id
1798: FROM ben_elig_per_elctbl_chc epe,
1799: ben_pil_elctbl_chc_popl pel,
1800: ben_enrt_bnft enb,
1801: ben_per_in_ler pil
1802: WHERE epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id (+)
1803: AND epe.per_in_ler_id = pil.per_in_ler_id
1804: AND epe.per_in_ler_id = pel.per_in_ler_id
1805: AND epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id

Line 1963: FROM ben_elig_per_f ep, ben_per_in_ler pil

1959: ep.rt_age_val,
1960: ep.rt_los_val,
1961: ep.rt_hrs_wkd_val,
1962: ep.rt_cmbn_age_n_los_val
1963: FROM ben_elig_per_f ep, ben_per_in_ler pil
1964: WHERE ep.person_id = c_person_id
1965: AND ep.pgm_id IS NULL
1966: AND ep.pl_id = c_pl_id
1967: AND c_effective_date BETWEEN ep.effective_start_date

Line 1985: FROM ben_elig_per_f ep, ben_elig_per_opt_f epo, ben_per_in_ler pil

1981: epo.rt_age_val,
1982: epo.rt_los_val,
1983: epo.rt_hrs_wkd_val,
1984: epo.rt_cmbn_age_n_los_val
1985: FROM ben_elig_per_f ep, ben_elig_per_opt_f epo, ben_per_in_ler pil
1986: WHERE ep.person_id = c_person_id
1987: AND ep.pgm_id IS NULL
1988: AND ep.pl_id = c_pl_id
1989: AND epo.opt_id = c_opt_id