APPS.HRI_OPL_BEN_ENRLACTN_EQ dependencies on BEN_PRTT_ENRT_RSLT_F

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;