APPS.BEN_DETERMINE_RATES dependencies on BEN_PER_IN_LER

Line 269: FROM ben_per_in_ler pil,

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

Line 277: FROM ben_per_in_ler b,

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

Line 1799: ben_per_in_ler pil

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

Line 1961: FROM ben_elig_per_f ep, ben_per_in_ler pil

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

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

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