APPS.BEN_REOPEN_ENDED_RESULTS dependencies on BEN_PTIP_F

Line 359: ,ben_ptip_f ptip

355: ,p_ptip_id number
356: ) is
357: select pen.*
358: from ben_prtt_enrt_rslt_f pen
359: ,ben_ptip_f ptip
360: where pen.effective_end_date = hr_api.g_eot -- '31-dec-4712'
361: and pen.enrt_cvg_thru_dt <> hr_api.g_eot -- '31-dec-4712'
362: and pen.prtt_enrt_rslt_stat_cd is null
363: and pen.person_id = p_person_id -- 318321