APPS.BEN_PRTT_REIMBMT_RQST_API dependencies on BEN_PRTT_RMT_APRVD_FR_PYMT_F

Line 153: ben_prtt_rmt_aprvd_fr_pymt_f pry

149: p_person_id number,
150: p_popl_yr_perd number ) is
151: select sum(nvl(pry.APRVD_FR_PYMT_AMT,0))
152: from ben_prtt_reimbmt_rqst_f prc,
153: ben_prtt_rmt_aprvd_fr_pymt_f pry
154: where prc.submitter_person_id = p_person_id
155: and prc.prtt_reimbmt_rqst_stat_cd not in ('DND','VOIDED','DPLICT')
156: and p_pl_id = prc.pl_id
157: and ((prc.popl_yr_perd_id_1 = p_popl_yr_perd and

Line 183: from ben_prtt_rmt_aprvd_fr_pymt_f pry

179: l_prc_overlap c_prc_overlap%rowtype;
180: --
181: cursor c_paid_amt (p_prtt_reimbmt_rqst_id number) is
182: select sum(nvl(pry.APRVD_FR_PYMT_AMT,0))
183: from ben_prtt_rmt_aprvd_fr_pymt_f pry
184: where pry.prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id;
185: --
186: l_paid_amt number;
187: l_pl_info c_pl_info%rowtype ;

Line 1123: from ben_prtt_rmt_aprvd_fr_pymt_f pry

1119: --
1120: cursor c_pry is
1121: select pry.prtt_rmt_aprvd_fr_pymt_id
1122: , pry.object_version_number
1123: from ben_prtt_rmt_aprvd_fr_pymt_f pry
1124: where pry.prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id;
1125: --
1126: -- end fix 2223214
1127: --