DBA Data[Home] [Help]

APPS.HXT_TIME_SUMMARY dependencies on HXT_TIMECARDS_F

Line 1349: FROM hxt_timecards_f tim,

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

Line 1351: hxt_timecards_f prev

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