1062: l_can_prtcpnt_enroll char(1);
1063: --
1064: cursor c_elctbl_chc is
1065: select count(*)
1066: from ben_elig_per_elctbl_chc epe,
1067: ben_pil_elctbl_chc_popl pcp,
1068: ben_per_in_ler pil,
1069: ben_ler_f ler
1070: where pil.person_id = to_number(l_person_id)
1186: l_can_prtcpnt_enroll char(1);
1187: --
1188: cursor c_elctbl_chc is
1189: select count(*)
1190: from ben_elig_per_elctbl_chc epe,
1191: ben_per_in_ler pil
1192: where pil.person_id = to_number(l_person_id)
1193: and epe.business_group_id+0 = to_number(l_business_group_id)
1194: and epe.PER_IN_LER_ID = pil.PER_IN_LER_ID