[Home] [Help]
178: prc.popl_yr_perd_id_1,
179: prc.popl_yr_perd_id_2,
180: prc.amt_year1,
181: prc.amt_year2
182: from ben_prtt_reimbmt_rqst_f prc
183: where p_rec.prtt_reimbmt_rqst_id = prc.prtt_reimbmt_rqst_id
184: and p_rec.business_group_id = prc.business_group_id
185: and p_effective_Date between prc.effective_start_date
186: and prc.effective_end_date ;
196: ,pl.cmpr_clms_to_cvg_or_bal_cd
197: ,prc.SUBMITTER_PERSON_ID
198: ,prc.PRTT_ENRT_RSLT_ID
199: ,prc.EXP_INCURD_DT
200: from ben_prtt_reimbmt_rqst_f prc,
201: ben_pl_f pl
202: where prc.prtt_reimbmt_rqst_id = p_rec.prtt_reimbmt_rqst_id
203: and pl.pl_id = prc.pl_id
204: and prc.EXP_INCURD_DT between pl.effective_start_date
208: cursor c_yr_amount (p_pl_id number ,
209: p_person_id number,
210: p_popl_yr_perd number ) is
211: select sum(nvl(pry.APRVD_FR_PYMT_AMT,0))
212: from ben_prtt_reimbmt_rqst_f prc,
213: ben_prtt_rmt_aprvd_fr_pymt_f pry
214: where prc.submitter_person_id = p_person_id
215: and prc.prtt_reimbmt_rqst_stat_cd not in ('DND','VOIDED','DPLICT')
216: and p_pl_id = prc.pl_id
228: popl_yr_perd_id_1,
229: popl_yr_perd_id_2,
230: amt_year1,
231: amt_year2
232: from ben_prtt_reimbmt_rqst_f prc
233: where prc.submitter_person_id = p_person_id
234: and prc.prtt_reimbmt_rqst_stat_cd not in ('DND','VOIDED','DPLICT')
235: and p_pl_id = prc.pl_id
236: and (( prc.popl_yr_perd_id_1 = p_popl_yr_perd and prc.amt_year2 is not null)
811: );
812: --
813: If ((nvl(p_prtt_reimbmt_rqst_id, hr_api.g_number) <> hr_api.g_number) and
814: NOT (dt_api.check_min_max_dates
815: (p_base_table_name => 'ben_prtt_reimbmt_rqst_f'
816: ,p_base_key_column => 'prtt_reimbmt_rqst_id'
817: ,p_base_key_value => p_prtt_reimbmt_rqst_id
818: ,p_from_date => p_validation_start_date
819: ,p_to_date => p_validation_end_date))) Then