APPS.BEN_DET_IMPUTED_INCOME dependencies on BEN_ELIG_PER_F

Line 505: from ben_elig_per_f pep

501: -- Bug 1884964 to restrict pen records from different set
502: and l_max_le_eff_date >= least(pen.effective_start_date,pen.enrt_cvg_strt_dt )
503: and exists
504: (select 'x'
505: from ben_elig_per_f pep
506: where pep.pl_id=pen.pl_id
507: and nvl(pep.pgm_id,-1)=nvl(pen.pgm_id,-1)
508: and pep.person_id=pen.person_id
509: and pep.per_in_ler_id = pil.per_in_ler_id

Line 526: -- from ben_elig_per_f pep2

522: -- (pep.PRTN_STRT_DT >= pen.enrt_cvg_strt_dt
523: -- and
524: -- pep.PRTN_STRT_DT =
525: -- (select min(pep2.PRTN_STRT_DT)
526: -- from ben_elig_per_f pep2
527: -- where pep.pl_id=pep2.pl_id
528: -- and nvl(pep.pgm_id,-1)=nvl(pep2.pgm_id,-1)
529: -- and pep.business_group_id = pep2.business_group_id)
530: -- and

Line 533: -- from ben_elig_per_f pep2

529: -- and pep.business_group_id = pep2.business_group_id)
530: -- and
531: -- pep.effective_start_date =
532: -- (select min(pep2.effective_start_date)
533: -- from ben_elig_per_f pep2
534: -- where pep.pl_id=pep2.pl_id
535: -- and pep.prtn_strt_dt=pep2.prtn_strt_dt
536: -- and nvl(pep.pgm_id,-1)=nvl(pep2.pgm_id,-1)
537: -- and pep.business_group_id = pep2.business_group_id)));

Line 569: from ben_elig_per_f pep

565: and l_max_le_eff_date >= least(pen.effective_start_date,pen.enrt_cvg_strt_dt )
566: and p_cvg_strt_dt between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
567: and exists
568: (select 'x'
569: from ben_elig_per_f pep
570: where pep.pl_id=pen.pl_id
571: and nvl(pep.pgm_id,-1)=nvl(pen.pgm_id,-1)
572: and pep.person_id=pen.person_id
573: and pep.per_in_ler_id = pil.per_in_ler_id

Line 591: -- from ben_elig_per_f pep2

587: -- (pep.PRTN_STRT_DT >= pen.enrt_cvg_strt_dt
588: -- and
589: -- pep.PRTN_STRT_DT =
590: -- (select min(pep2.PRTN_STRT_DT)
591: -- from ben_elig_per_f pep2
592: -- where pep.pl_id=pep2.pl_id
593: -- and nvl(pep.pgm_id,-1)=nvl(pep2.pgm_id,-1)
594: -- and pep.business_group_id = pep2.business_group_id)
595: -- and

Line 598: -- from ben_elig_per_f pep2

594: -- and pep.business_group_id = pep2.business_group_id)
595: -- and
596: -- pep.effective_start_date =
597: -- (select min(pep2.effective_start_date)
598: -- from ben_elig_per_f pep2
599: -- where pep.pl_id=pep2.pl_id
600: -- and pep.prtn_strt_dt=pep2.prtn_strt_dt
601: -- and nvl(pep.pgm_id,-1)=nvl(pep2.pgm_id,-1)
602: -- and pep.business_group_id = pep2.business_group_id)));