APPS.BEN_FORFEITURE_CONCURRENT dependencies on BEN_PRTT_REIMBMT_RQST_F

Line 445: from ben_prtt_reimbmt_rqst_f prc,

441: cursor c_rmbrq_total (p_pl_id number, p_person_id number,
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')