APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on PER_TIME_PERIODS

Line 62: FROM hxt_timecards_f HTF, per_time_periods ptp

58: p_person_id hxt_timecards_f.for_person_id%TYPE
59: )
60: IS
61: SELECT HTF.ID
62: FROM hxt_timecards_f HTF, per_time_periods ptp
63: WHERE HTF.for_person_id = p_person_id
64: AND HTF.time_period_id = ptp.time_period_id
65: AND TRUNC (p_date_worked) BETWEEN TRUNC (ptp.start_date)
66: AND TRUNC (ptp.end_date);

Line 287: FROM per_time_periods

283: BEGIN
284: --
285: SELECT time_period_id, start_date, end_date
286: INTO l_time_period_id, l_start_date, l_end_date
287: FROM per_time_periods
288: WHERE payroll_id = p_payroll_id
289: AND TRUNC (p_date_worked) BETWEEN TRUNC (start_date)
290: AND TRUNC (end_date);
291: