[Home] [Help]
APPS.HXT_TIME_SUMMARY dependencies on PER_TIME_PERIODS
Line 1350: per_time_periods ptp,
1346: p_person_id NUMBER)
1347: IS SELECT /*+ ORDERED */
1348: prev.id
1349: FROM hxt_timecards_f tim,
1350: per_time_periods ptp,
1351: hxt_timecards_f prev
1352: WHERE tim.id = p_tim_id
1353: AND p_session_date BETWEEN tim.effective_start_date
1354: AND tim.effective_end_date