DBA Data[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