DBA Data[Home] [Help]

APPS.BEN_CPY_BUS dependencies on BEN_PRTT_REIMBMT_RQST_F

Line 702: from ben_prtt_reimbmt_rqst_f prc

698: where a.yr_perd_id = p_yr_perd_id;
699: --
700: cursor c_claims (p_pl_id number) is
701: select null
702: from ben_prtt_reimbmt_rqst_f prc
703: where prc.EXP_INCURD_DT > p_py_clms_thru_dt
704: and prc.pl_id = p_pl_id
705: and prc.popl_yr_perd_id_1 = p_yr_perd_id
706: and prc.prtt_reimbmt_rqst_stat_cd in ('APPRVD','PDINFL','PRTLYPD');