APPS.BEN_PREM_PRTT_CREDITS_MO dependencies on BEN_PRTT_ENRT_RSLT_F

Line 38: from ben_prtt_enrt_rslt_f pen, ben_prtt_prem_f ppe,

34: pen.pl_id, pen.oipl_id, pen.person_id, pen.ler_id, pen.pl_typ_id,
35: pen.prtt_enrt_rslt_stat_cd, pen.sspndd_flag, pil.per_in_ler_stat_cd,
36: pen.effective_start_date, pen.effective_end_date,
37: pen.enrt_cvg_strt_dt
38: from ben_prtt_enrt_rslt_f pen, ben_prtt_prem_f ppe,
39: ben_per_in_ler pil
40: ,ben_prtt_prem_by_mo_f prm, ben_actl_prem_f apr
41: where
42: ( (pen.sspndd_flag = 'N'

Line 88: from ben_prtt_enrt_rslt_f p where p.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id)

84: -- INTERIM dt-ended before cvg started criteria (PRO):
85: or (pen.prtt_enrt_rslt_stat_cd is null
86: -- rows where result was ended, not just date-track updated.
87: and pen.object_version_number = (select max(object_version_number)
88: from ben_prtt_enrt_rslt_f p where p.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id)
89: -- cvg started sometime this month - a pro prem could have been written
90: and pen.enrt_cvg_strt_dt between p_first_day_of_month and p_effective_date
91: -- result effective END date is this month
92: and pen.effective_end_date between