APPS.BEN_FORFEITURE_CONCURRENT dependencies on BEN_PRTT_RMT_APRVD_FR_PYMT_F

Line 446: ben_prtt_rmt_aprvd_fr_pymt_f pry

442: p_effective_date date,
443: p_start_date date, p_end_date date) is
444: select sum(nvl(pry.aprvd_fr_pymt_amt,0))
445: from ben_prtt_reimbmt_rqst_f prc,
446: ben_prtt_rmt_aprvd_fr_pymt_f pry
447: where prc.pl_id = p_pl_id
448: and prc.prtt_reimbmt_rqst_stat_cd in ( 'APPRVD','PDINFL','PRTLYPD')
449: and nvl(pry.pymt_stat_cd,' ') <> ('RMBPNDNG')
450: and p_effective_date between prc.effective_start_date