DBA Data[Home] [Help]

APPS.BEN_PRTT_REIMBMT_RQST_API dependencies on BEN_YR_PERD

Line 191: from ben_yr_perd yrp,

187: l_pl_info c_pl_info%rowtype ;
188: --
189: cursor c_yr_perd(p_popl_yr_perd_id number) is
190: select END_DATE
191: from ben_yr_perd yrp,
192: ben_popl_yr_perd cpy
193: where cpy.popl_yr_perd_id = p_popl_yr_perd_id
194: and cpy.yr_perd_id = yrp.yr_perd_id;
195: --

Line 428: ben_yr_perd yrp

424: --
425: cursor c1 is
426: select popl_yr_perd_id
427: from ben_popl_yr_perd cpy,
428: ben_yr_perd yrp
429: where p_exp_incurd_dt between yrp.start_date
430: and nvl(cpy.PY_CLMS_THRU_DT,yrp.end_date)
431: and p_effective_date between yrp.start_date
432: and nvl(cpy.ACPT_CLM_RQSTS_THRU_DT,yrp.end_date)