APPS.BEN_DET_IMPUTED_INCOME dependencies on BEN_ELIG_PER_F

Line 92: from ben_elig_per_f pep

88: -- Bug 1884964 to restrict pen records from different set
89: and l_max_le_eff_date >= least(pen.effective_start_date,pen.enrt_cvg_strt_dt )
90: and exists
91: (select 'x'
92: from ben_elig_per_f pep
93: where pep.pl_id=pen.pl_id
94: and nvl(pep.pgm_id,-1)=nvl(pen.pgm_id,-1)
95: and pep.person_id=pen.person_id
96: and pep.per_in_ler_id = pil.per_in_ler_id

Line 113: -- from ben_elig_per_f pep2

109: -- (pep.PRTN_STRT_DT >= pen.enrt_cvg_strt_dt
110: -- and
111: -- pep.PRTN_STRT_DT =
112: -- (select min(pep2.PRTN_STRT_DT)
113: -- from ben_elig_per_f pep2
114: -- where pep.pl_id=pep2.pl_id
115: -- and nvl(pep.pgm_id,-1)=nvl(pep2.pgm_id,-1)
116: -- and pep.business_group_id = pep2.business_group_id)
117: -- and

Line 120: -- from ben_elig_per_f pep2

116: -- and pep.business_group_id = pep2.business_group_id)
117: -- and
118: -- pep.effective_start_date =
119: -- (select min(pep2.effective_start_date)
120: -- from ben_elig_per_f pep2
121: -- where pep.pl_id=pep2.pl_id
122: -- and pep.prtn_strt_dt=pep2.prtn_strt_dt
123: -- and nvl(pep.pgm_id,-1)=nvl(pep2.pgm_id,-1)
124: -- and pep.business_group_id = pep2.business_group_id)));