[Home] [Help]
105: -- Assuming person can't be in same plan in two programs.
106: -- if they are, they will be counted twice due to this cursor.
107: cursor c_people is
108: select distinct pen.person_id , pen.pgm_id, nvl(pen.bnft_amt,0) bnft_amt
109: from ben_prtt_enrt_rslt_f pen,
110: per_all_people_f per -- Bug 1750817 : Filter out enrollments of deleted person.
111: where per.person_id = pen.person_id
112: and per.business_group_id = pen.business_group_id
113: and p_effective_date between per.effective_start_date
497: cursor c_results (p_first_day_of_month date,
498: p_last_day_of_month date, p_wsh_rl_dy_mo_num number,
499: p_pl_id number, p_oipl_id number) is
500: select count('s') num_of_prtts, sum(nvl(pen.bnft_amt,0)) total_cvg
501: from ben_prtt_enrt_rslt_f pen,
502: per_all_people_f per -- Bug 1750817 : Filter out enrollments of deleted person.
503: where per.person_id = pen.person_id
504: and per.business_group_id = pen.business_group_id
505: and p_effective_date between per.effective_start_date
547: pen.pgm_id, pen.pl_typ_id,
548: /* Start of Code Change for WWBUG: 1646442: added following table */
549: pen.enrt_cvg_strt_dt
550: /* End of Code Change for WWBUG: 1646442 */
551: from ben_prtt_enrt_rslt_f pen,
552: per_all_people_f per -- Bug 1750817 : Filter out enrollments of deleted person.
553: where per.person_id = pen.person_id
554: and per.business_group_id = pen.business_group_id
555: and p_effective_date between per.effective_start_date