APPS.HXT_TD_UTIL dependencies on PER_TIME_PERIODS

Line 25: per_time_periods ptp

21: IS SELECT ptp.start_date,
22: ptp.end_date,
23: tim.for_person_id
24: FROM hxt_timecards_f tim,
25: per_time_periods ptp
26: WHERE tim.id = p_id
27: AND tim.time_period_id = ptp.time_period_id ;
28:
29: l_start DATE;

Line 38: -- Get start.end dates of the timecard from per_time_periods.

34:
35: BEGIN
36:
37:
38: -- Get start.end dates of the timecard from per_time_periods.
39: OPEN get_period(p_timecard_id);
40: FETCH get_period INTO l_start,l_end,l_resource_id;
41: CLOSE get_period;
42:

Line 1472: FROM per_time_periods ptp, per_time_period_types ptpt

1468:
1469: CURSOR num_periods_cur
1470: IS
1471: SELECT ptpt.number_per_fiscal_year
1472: FROM per_time_periods ptp, per_time_period_types ptpt
1473: WHERE p_ptp_id = ptp.time_period_id
1474: AND ptp.period_type = ptpt.period_type;
1475:
1476: v_proposed_salary per_pay_proposals_v.proposed_salary%TYPE;