DBA Data[Home] [Help]

APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_YR_PERD

Line 16069: FROM ben_yr_perd yrp1

16065: SELECT yrp1.start_date
16066: , yrp1.end_date
16067: , yrp2.start_date
16068: , yrp2.end_date
16069: FROM ben_yr_perd yrp1
16070: , ben_yr_perd yrp2
16071: , ben_popl_yr_perd byrp
16072: WHERE yrp1.yr_perd_id = p_yr_perd_id
16073: AND byrp.pl_id = p_pl_id

Line 16070: , ben_yr_perd yrp2

16066: , yrp1.end_date
16067: , yrp2.start_date
16068: , yrp2.end_date
16069: FROM ben_yr_perd yrp1
16070: , ben_yr_perd yrp2
16071: , ben_popl_yr_perd byrp
16072: WHERE yrp1.yr_perd_id = p_yr_perd_id
16073: AND byrp.pl_id = p_pl_id
16074: AND byrp.business_group_id + 0 = p_target_business_group_id