DBA Data[Home] [Help]

APPS.BEN_PREM_PRTT_CREDITS_MO dependencies on BEN_YR_PERD

Line 202: from ben_yr_perd yrp, ben_popl_yr_perd cpy

198:
199: -- plan year period for the effective date and the plan:
200: cursor c_pl_yr (p_pgm_id number, p_pl_id number) is
201: select yrp.start_date
202: from ben_yr_perd yrp, ben_popl_yr_perd cpy
203: where yrp.business_group_id+0 = p_business_group_id
204: and p_effective_date between
205: yrp.start_date and yrp.end_date
206: and yrp.yr_perd_id = cpy.yr_perd_id