APPS.HXT_TIME_COLLECTION dependencies on HXT_TIMECARDS_F

Line 573: FROM hxt_timecards_f tim,

569: -- Bug 9790410
570: -- To find out if the timecard being edited is Archived.
571: CURSOR get_archived_status(p_id IN NUMBER)
572: IS SELECT 1
573: FROM hxt_timecards_f tim,
574: hxc_data_sets hds
575: WHERE tim.id = p_id
576: AND tim.data_set_id = hds.data_set_id
577: AND hds.status IN ('OFF_LINE','RESTORE_IN_PROGRESS','ARCHIVE_IN_PROGRESS');

Line 3041: FROM hxt_timecards_f tim, --SIR290

3037: c_tim_start_date DATE
3038: )
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

Line 3398: FROM hxt_timecards_f

3394: END IF;
3395:
3396: SELECT ID, auto_gen_flag, batch_id
3397: INTO o_timecard_id, o_auto_gen_flag, g_batch_err_id
3398: FROM hxt_timecards_f
3399: WHERE for_person_id = i_person_id AND time_period_id = i_time_period_id;
3400:
3401: IF g_debug
3402: THEN

Line 3563: /* INSERT into hxt_timecards_f

3559: END IF;
3560:
3561: --
3562: /* Insert new timecard info to hxt_timecards */
3563: /* INSERT into hxt_timecards_f
3564: ( id,
3565: for_person_id,
3566: payroll_id,
3567: time_period_id,