APPS.HXT_TIME_COLLECTION dependencies on PER_TIME_PERIODS

Line 22: period_id per_time_periods.time_period_id%TYPE,

18:
19: TYPE batch_info_rec IS RECORD (
20: batch_id pay_batch_headers.batch_id%TYPE,
21: batch_ref pay_batch_headers.batch_reference%TYPE,
22: period_id per_time_periods.time_period_id%TYPE,
23: num_tcs NUMBER
24: );
25:
26: TYPE batch_info_table IS TABLE OF batch_info_rec

Line 155: p_time_period_id IN per_time_periods.time_period_id%TYPE,

151: )
152: RETURN NUMBER;
153:
154: FUNCTION find_existing_batch (
155: p_time_period_id IN per_time_periods.time_period_id%TYPE,
156: p_batch_reference IN pay_batch_headers.batch_reference%TYPE
157: )
158: RETURN pay_batch_headers.batch_id%TYPE;
159:

Line 484: l_time_period_id per_time_periods.time_period_id%TYPE

480: l_task_id hxt_tasks_v.task_id%TYPE DEFAULT NULL;
481: l_location_id hr_locations.location_id%TYPE DEFAULT NULL;
482: l_project_id hxt_sum_hours_worked.project_id%TYPE
483: DEFAULT NULL;
484: l_time_period_id per_time_periods.time_period_id%TYPE
485: DEFAULT NULL;
486: l_start_date DATE DEFAULT NULL;
487: l_end_date DATE DEFAULT NULL;
488: l_auto_gen_flag hxt_timecards.auto_gen_flag%TYPE

Line 3028: per_time_periods ptp --SIR286

3024: IS
3025: SELECT tim.for_person_id, tbh.status, ptp.start_date --SIR286
3026: FROM hxt_timecards tim, --SIR290
3027: hxt_batch_states tbh,
3028: per_time_periods ptp --SIR286
3029: WHERE tim.ID = c_tim_id
3030: AND tbh.batch_id = tim.batch_id
3031: AND ptp.time_period_id = tim.time_period_id -- SIR286
3032: ; --SIR290

Line 3043: per_time_periods ptp --SIR286

3039: IS
3040: SELECT tim.for_person_id, tbh.status, ptp.start_date --SIR286
3041: FROM hxt_timecards_f tim, --SIR290
3042: hxt_batch_states tbh,
3043: per_time_periods ptp --SIR286
3044: WHERE tim.ID = c_tim_id
3045: AND tbh.batch_id = tim.batch_id
3046: AND ptp.time_period_id = tim.time_period_id
3047: AND c_tim_start_date BETWEEN effective_start_date

Line 3359: FROM per_time_periods

3355: IS
3356: BEGIN
3357: SELECT time_period_id, start_date, end_date
3358: INTO o_time_period, o_start_date, o_end_date
3359: FROM per_time_periods
3360: WHERE payroll_id = i_payroll_id
3361: AND TRUNC (i_date_worked) BETWEEN TRUNC (start_date) AND TRUNC
3362: (end_date);
3363:

Line 3854: p_time_period_id IN per_time_periods.time_period_id%TYPE,

3850: batches must be in a hold status (batch_status = 'H')
3851: and have less than the max amount of timecards allowed per batch.
3852: ********************************************************************/
3853: FUNCTION find_existing_batch (
3854: p_time_period_id IN per_time_periods.time_period_id%TYPE,
3855: p_batch_reference IN pay_batch_headers.batch_reference%TYPE
3856: )
3857: RETURN pay_batch_headers.batch_id%TYPE
3858: IS

Line 3860: p_time_period_id per_time_periods.time_period_id%TYPE,

3856: )
3857: RETURN pay_batch_headers.batch_id%TYPE
3858: IS
3859: CURSOR csr_timecard_batches (
3860: p_time_period_id per_time_periods.time_period_id%TYPE,
3861: p_batch_reference pay_batch_headers.batch_reference%TYPE
3862: )
3863: IS
3864: SELECT COUNT (ht.ID) num_tcs, MAX (ht.batch_id) batch_id