661: pil.ler_id,
662: epe.business_group_id,
663: epe.enrt_cvg_strt_dt
664: from ben_per_in_ler pil,
665: ben_elig_per_elctbl_chc epe
666: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
667: and epe.per_in_ler_id = pil.per_in_ler_id;
668: --
669: cursor c_opt(l_oipl_id number) is
887: cursor c_pil_popl is
888: select pel.enrt_perd_end_dt,
889: pel.procg_end_dt
890: from ben_pil_elctbl_chc_popl pel,
891: ben_elig_per_elctbl_chc epe
892: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
893: and epe.business_group_id = l_business_group_id
894: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
895: and pel.business_group_id = l_business_group_id;
7330: epe.per_in_ler_id,
7331: pil.person_id,
7332: epe.fonm_cvg_strt_dt
7333: from
7334: ben_elig_per_elctbl_chc epe,
7335: ben_pil_elctbl_chc_popl pel,
7336: ben_per_in_ler pil
7337: where
7338: epe.elig_per_elctbl_chc_id=p_elig_per_elctbl_chc_id and