APPS.HXT_BATCH_PROCESS dependencies on HXT_TIMECARDS_F

Line 61: l_ovn HXT_TIMECARDS_F.OBJECT_VERSION_NUMBER%TYPE;

57: l_valid_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
58: l_error_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
59: l_warning_batch_name PAY_BATCH_HEADERS.BATCH_NAME%TYPE;
60: l_object_version_number PAY_BATCH_HEADERS.OBJECT_VERSION_NUMBER%TYPE;
61: l_ovn HXT_TIMECARDS_F.OBJECT_VERSION_NUMBER%TYPE;
62: l_string1 VARCHAR2(5);
63: l_string2 VARCHAR2(5);
64: l_loop_index1 BINARY_INTEGER;
65: l_loop_index2 BINARY_INTEGER;

Line 1661: hxt_timecards_f tim,

1657: where batch_id = p_batch_id;
1658: cursor c_get_retro_batch_ids(p_batch_id number) is
1659: SELECT distinct(hrw.retro_batch_id) retro_batch_id,pbh.object_version_number
1660: FROM hxt_det_hours_worked_f hrw,
1661: hxt_timecards_f tim,
1662: pay_batch_headers pbh
1663: WHERE hrw.tim_id = tim.id
1664: AND tim.batch_id = pbh.batch_id
1665: AND tim.batch_id = p_batch_id

Line 1727: hxt_timecards_f tim

1723: pbl_line_id = NULL
1724: WHERE rowid in (
1725: SELECT hrw.rowid
1726: FROM hxt_det_hours_worked_f hrw,
1727: hxt_timecards_f tim
1728: WHERE hrw.tim_id = tim.id
1729: AND tim.batch_id=p_batch_id);
1730: -- step 4 - SET the date_earned (Process Date) back to NULL on the hxt_batch_states table
1731: UPDATE hxt_batch_states