DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_POPL_YR_PERD

Line 1178: FROM ben_popl_yr_perd pyp

1174: ,p_pgm_id number
1175: ,p_business_group_id number
1176: ) is
1177: SELECT distinct yp.start_date
1178: FROM ben_popl_yr_perd pyp
1179: ,ben_yr_perd yp
1180: WHERE (pyp.pl_id = p_pl_id or pyp.pgm_id = p_pgm_id)
1181: AND pyp.yr_perd_id = yp.yr_perd_id
1182: AND pyp.business_group_id = p_business_group_id