APPS.HXT_OTC_RETRIEVAL_INTERFACE dependencies on PER_TIME_PERIODS

Line 456: FROM hxt_timecards_f HTF, per_time_periods ptp

452: p_person_id hxt_timecards_f.for_person_id%TYPE
453: )
454: IS
455: SELECT HTF.ID
456: FROM hxt_timecards_f HTF, per_time_periods ptp
457: WHERE HTF.for_person_id = p_person_id
458: AND HTF.time_period_id = ptp.time_period_id
459: AND TRUNC (p_date_worked) BETWEEN TRUNC (ptp.start_date)
460: AND TRUNC (ptp.end_date);

Line 788: FROM per_time_periods

784: BEGIN
785: --
786: SELECT time_period_id, start_date, end_date
787: INTO l_time_period_id, l_start_date, l_end_date
788: FROM per_time_periods
789: WHERE payroll_id = p_payroll_id
790: AND TRUNC (p_date_worked) BETWEEN TRUNC (start_date)
791: AND TRUNC (end_date);
792: