APPS.BEN_DETERMINE_ELCT_CHC_FLX_IMP dependencies on BEN_YR_PERD
Line 499: from ben_yr_perd yp,
495:
496:
497: cursor yr_perd_for_pgm (p_pgm_id in number) is
498: select yp.yr_perd_id 499: from ben_yr_perd yp, 500: ben_popl_yr_perd pop
501: where pop.pgm_id = p_pgm_id
502: and pop.yr_perd_id = yp.yr_perd_id
503: and nvl(p_lf_evt_ocrd_dt,p_effective_date)