APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on BEN_PRTT_ENRT_RSLT_F

Line 638: From ben_prtt_enrt_rslt_f pen,

634: -- Cursors declaration.
635: --
636: cursor c_person is
637: Select distinct ecd.dpnt_person_id, pil.person_id
638: From ben_prtt_enrt_rslt_f pen,
639: ben_elig_cvrd_dpnt_f ecd,
640: ben_per_in_ler pil
641: Where pen.business_group_id = p_business_group_id
642: and pen.prtt_enrt_rslt_stat_cd is null

Line 1231: From ben_prtt_enrt_rslt_f pen,

1227: ctr.contact_type,
1228: ctr.date_end, -- 5100008 Added this
1229: -- CWB Changes.
1230: ecd.per_in_ler_id
1231: From ben_prtt_enrt_rslt_f pen,
1232: ben_elig_cvrd_dpnt_f ecd,
1233: ben_per_in_ler pil,
1234: per_contact_relationships ctr
1235: Where pen.business_group_id = p_business_group_id