APPS.HXT_BATCH_PROCESS dependencies on HXT_TIMECARDS_F

Line 467: l_ovn HXT_TIMECARDS_F.OBJECT_VERSION_NUMBER%TYPE;

463: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
464: l_error_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
465: l_warning_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
466: l_object_version_number PAY_BATCH_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
467: l_ovn HXT_TIMECARDS_F.OBJECT_VERSION_NUMBER%TYPE;
468: l_string1 VARCHAR2(5);
469: l_string2 VARCHAR2(5);
470: l_loop_index1 BINARY_INTEGER;
471: l_loop_index2 BINARY_INTEGER;

Line 846: hxt_timecards_f tim

842: WHERE tim.batch_id = pbh.batch_id
843: ) --bug 5748118
844: AND NOT EXISTS ( SELECT 1
845: FROM hxc_data_sets hds,
846: hxt_timecards_f tim
847: WHERE tim.batch_id = pbh.batch_id
848: AND hds.data_set_id = tim.data_set_id
849: AND hds.status IN ('OFF_LINE','ARCHIVE_IN_PROGRESS','RESTORE_IN_PROGRESS')
850: )

Line 2742: hxt_timecards_f tim,

2738: /*
2739: cursor c_get_retro_batch_ids(p_batch_id number) is
2740: SELECT distinct(hrw.retro_batch_id) retro_batch_id,pbh.object_version_number
2741: FROM hxt_det_hours_worked_f hrw,
2742: hxt_timecards_f tim,
2743: pay_batch_headers pbh
2744: WHERE hrw.tim_id = tim.id
2745: AND tim.batch_id = pbh.batch_id
2746: AND tim.batch_id = p_batch_id

Line 2754: hxt_timecards_f tim,

2750: cursor c_get_retro_batch_ids(p_batch_id number) is
2751: SELECT distinct(hrw.retro_batch_id) retro_batch_id,pbh.object_version_number,
2752: pbh.batch_status
2753: FROM hxt_det_hours_worked_f hrw,
2754: hxt_timecards_f tim,
2755: pay_batch_headers pbh
2756: WHERE hrw.tim_id = tim.id
2757: AND hrw.retro_batch_id = pbh.batch_id
2758: AND tim.batch_id = p_batch_id

Line 2863: hxt_timecards_f tim

2859: pbl_line_id = NULL
2860: WHERE rowid in (
2861: SELECT hrw.rowid
2862: FROM hxt_det_hours_worked_f hrw,
2863: hxt_timecards_f tim
2864: WHERE hrw.tim_id = tim.id
2865: AND tim.batch_id=p_batch_id);
2866:
2867: -- Bug 13388573

Line 3134: FROM hxt_timecards_f

3130:
3131: -- To pick up each timecard in the batch.
3132: CURSOR get_timecards(p_batch_id IN NUMBER)
3133: IS SELECT id
3134: FROM hxt_timecards_f
3135: WHERE batch_id = p_batch_id;
3136:
3137:
3138: -- To pick up the individual details