APPS.BEN_EXT_CONTACT dependencies on BEN_PRTT_ENRT_RSLT_F

Line 241: ben_prtt_enrt_rslt_f pen

237: --
238: cursor c_cvrd_dpnt (p_contact_person_id number) is
239: select 'Y'
240: from ben_elig_cvrd_dpnt_f pdp,
241: ben_prtt_enrt_rslt_f pen
242: where pdp.dpnt_person_id = p_contact_person_id
243: and pen.person_id = p_person_id
244: and pen.prtt_enrt_rslt_stat_cd not in ('VOIDD','BCKDT')
245: and pen.sspndd_flag = 'N'

Line 257: ben_prtt_enrt_rslt_f pen

253: --
254: cursor c_beneficiary (p_contact_person_id number) is
255: select 'Y'
256: from ben_pl_bnf_f pbn,
257: ben_prtt_enrt_rslt_f pen
258: where pbn.bnf_person_id = p_contact_person_id
259: and pen.person_id = p_person_id
260: and pen.prtt_enrt_rslt_stat_cd not in ('VOIDD','BCKDT')
261: and pen.sspndd_flag = 'N'