APPS.BEN_EXT_ENRT dependencies on BEN_PRTT_PREM_F

Line 715: from ben_prtt_prem_f ppr,

711: cursor prem_tot_c(l_prtt_enrt_rslt_id number) is
712: select
713: sum(ppr.std_prem_val)
714: , ppr.std_prem_uom
715: from ben_prtt_prem_f ppr,
716: ben_per_in_ler pil
717: where ppr.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
718: and p_effective_date between nvl(ppr.effective_start_date, p_effective_date)
719: and nvl(ppr.effective_end_date, p_effective_date)

Line 771: , ben_prtt_prem_f ppe

767: cursor c_mntot_prem(l_prtt_enrt_rslt_id number) is
768: select sum(prm.val)
769: ,sum(prm.cr_val)
770: from ben_prtt_prem_by_mo_f prm
771: , ben_prtt_prem_f ppe
772: where ppe.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
773: and ppe.prtt_prem_id = prm.prtt_prem_id
774: and prm.yr_num = to_number(to_char(p_effective_date,'YYYY'))
775: and prm.mo_num = to_number(to_char(p_effective_date,'MM'));