APPS.BEN_EXT_ELIG dependencies on BEN_PTIP_F

Line 956: ben_ptip_f ptip -- 2732104

952: ben_plip_f plip,
953: ben_oipl_f oipl,
954: ben_pgm_f pgm,
955: ben_pl_typ_f ptp,
956: ben_ptip_f ptip -- 2732104
957: where pler.person_id = p_person_id
958: and pler.per_in_ler_id = echc.per_in_ler_id
959: and echc.pil_elctbl_chc_popl_id = ppopl.pil_elctbl_chc_popl_id
960: and echc.elctbl_flag = 'Y'

Line 1254: from ben_ptip_f ptip

1250: cursor c_ptip (p_ptip_id number ,
1251: p_effective_date date) is
1252: select ptip.short_name ptip_fd_name,
1253: ptip.short_code ptip_fd_code
1254: from ben_ptip_f ptip
1255: where p_ptip_id = ptip.ptip_id
1256: and p_effective_date
1257: between ptip.effective_start_date and ptip.effective_end_date
1258: ;