[Home] [Help]
252: --
253: --
254: cursor c_pil is
255: select count(*)
256: from ben_per_in_ler pil
257: where pil.person_id = to_number(l_person_id)
258: and pil.business_group_id = to_number(l_business_group_id)
259: and pil.per_in_ler_stat_cd = 'STRTD';
260: /* and to_date(l_effective_date, 'dd/mm/yyyy')
484: l_package varchar2(80) := g_package||'.p_evt_lf_events';
485: --
486: type l_le_rec is record
487: (name ben_ler_f.name%type,
488: lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type);
489: --
490: type l_le_table is table of l_le_rec
491: index by binary_integer;
492: --
524: ler.ler_id,
525: pil.lf_evt_ocrd_dt,
526: pil.per_in_ler_stat_cd,
527: pel.dflt_enrt_dt
528: from ben_per_in_ler pil,
529: ben_ler_f ler,
530: ben_pil_elctbl_chc_popl pel
531: where pil.ler_id = ler.ler_id
532: and pil.per_in_ler_id = pel.per_in_ler_id
552: pil.per_in_ler_stat_cd,
553: pel.dflt_enrt_dt
554: from per_contact_relationships csr, --?? will be _f
555: per_people_f ppf,
556: ben_per_in_ler pil,
557: ben_ler_f ler,
558: ben_pil_elctbl_chc_popl pel
559: where csr.person_id = l_person_id
560: and ppf.person_id = csr.contact_person_id
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)
1071: and pil.per_in_ler_id = pcp.per_in_ler_id
1072: and pcp.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
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
1195: and pil.business_group_id+0 = to_number(l_business_group_id)