APPS.BEN_PREM_PL_OIPL_MONTHLY dependencies on PER_ALL_PEOPLE_F

Line 110: per_all_people_f per -- Bug 1750817 : Filter out enrollments of deleted person.

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
114: and per.effective_end_date

Line 502: per_all_people_f per -- Bug 1750817 : Filter out enrollments of deleted person.

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
506: and per.effective_end_date

Line 552: per_all_people_f per -- Bug 1750817 : Filter out enrollments of deleted person.

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
556: and per.effective_end_date