APPS.BEN_PRTT_REIMBMT_RQST_API dependencies on BEN_POPL_YR_PERD

Line 192: ben_popl_yr_perd cpy

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: --
196: l_yr_end date;

Line 427: from ben_popl_yr_perd cpy,

423: p_popl_yr_perd_id_2 out nocopy number) is
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