APPS.BEN_REOPEN_ENDED_RESULTS dependencies on BEN_PTIP_F

Line 397: ,ben_ptip_f ptip

393: ,p_ptip_id number
394: ) is
395: select pen.*
396: from ben_prtt_enrt_rslt_f pen
397: ,ben_ptip_f ptip
398: where pen.effective_end_date = hr_api.g_eot -- '31-dec-4712'
399: and pen.enrt_cvg_thru_dt <> hr_api.g_eot -- '31-dec-4712'
400: and pen.prtt_enrt_rslt_stat_cd is null
401: and pen.person_id = p_person_id -- 318321