DBA Data[Home] [Help]

APPS.HR_PRE_PAY dependencies on PER_TIME_PERIODS

Line 2497: FROM per_time_periods ptp

2493: pee.effective_start_date and pee.effective_end_date)
2494: OR exists
2495: (
2496: SELECT 1
2497: FROM per_time_periods ptp
2498: WHERE ptp.time_period_id = ppa.time_period_id
2499: AND pee.effective_end_date BETWEEN ptp.start_date AND ptp.end_date
2500: and pee.effective_end_date = l_max_eff_end_date
2501: )