APPS.HXT_TIME_CLOCK dependencies on PER_TIME_PERIODS

Line 59: l_time_period_id per_time_periods.time_period_id%TYPE DEFAULT NULL;

55: l_first_name per_people_f.first_name%TYPE DEFAULT NULL;
56: l_bus_grp_id per_assignments_f.business_group_id%TYPE DEFAULT NULL;
57: l_timecard_id hxt_timecards.id%TYPE DEFAULT NULL;
58: l_date_worked DATE DEFAULT NULL;
59: l_time_period_id per_time_periods.time_period_id%TYPE DEFAULT NULL;
60: l_start_date DATE DEFAULT NULL;
61: l_end_date DATE DEFAULT NULL;
62: l_auto_gen_flag hxt_timecards.auto_gen_flag%TYPE DEFAULT NULL;
63: l_timecard_exists BOOLEAN DEFAULT TRUE;

Line 575: FROM per_time_periods

571: end_date
572: INTO o_time_period,
573: o_start_date,
574: o_end_date
575: FROM per_time_periods
576: WHERE payroll_id = i_payroll_id
577: AND TRUNC(i_date_worked) BETWEEN TRUNC(start_date) AND TRUNC(end_date);
578: RETURN 0;
579: EXCEPTION