APPS.HRI_OPL_BEN_ENRLACTN_EQ dependencies on BEN_PER_IN_LER

Line 39: FROM ben_per_in_ler

35: --
36: CURSOR c_date
37: IS
38: SELECT lf_evt_ocrd_dt
39: FROM ben_per_in_ler
40: WHERE per_in_ler_id = p_per_in_ler_id;
41:
42: --
43: l_date DATE;

Line 79: FROM ben_prtt_enrt_rslt_f pen, ben_per_in_ler pil

75: CURSOR c_pen
76: IS
77: SELECT pil.person_id, pen.pgm_id, pen.pl_id, pen.oipl_id,
78: pen.sspndd_flag, pil.lf_evt_ocrd_dt
79: FROM ben_prtt_enrt_rslt_f pen, ben_per_in_ler pil
80: WHERE pil.per_in_ler_id = p_rec.per_in_ler_id
81: AND pen.prtt_enrt_rslt_id = p_rec.prtt_enrt_rslt_id
82: AND p_effective_date BETWEEN pen.effective_start_date
83: AND pen.effective_end_date;