DBA Data[Home] [Help]

APPS.BEN_EXT_ENRT dependencies on BEN_PRTT_PREM_BY_MO_F

Line 770: from ben_prtt_prem_by_mo_f prm

766: --
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'))