1345: p_week_start DATE,
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
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
1355: AND tim.payroll_id = ptp.payroll_id