APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on BEN_PRTT_ENRT_RSLT_F

Line 643: From ben_prtt_enrt_rslt_f pen,

639: -- Cursors declaration.
640: --
641: cursor c_person is
642: Select distinct ecd.dpnt_person_id, pil.person_id
643: From ben_prtt_enrt_rslt_f pen,
644: ben_elig_cvrd_dpnt_f ecd,
645: ben_per_in_ler pil
646: Where pen.business_group_id = p_business_group_id
647: and pen.prtt_enrt_rslt_stat_cd is null

Line 1236: From ben_prtt_enrt_rslt_f pen,

1232: ctr.contact_type,
1233: ctr.date_end, -- 5100008 Added this
1234: -- CWB Changes.
1235: ecd.per_in_ler_id
1236: From ben_prtt_enrt_rslt_f pen,
1237: ben_elig_cvrd_dpnt_f ecd,
1238: ben_per_in_ler pil,
1239: per_contact_relationships ctr
1240: Where pen.business_group_id = p_business_group_id