APPS.HXT_BATCH_PROCESS dependencies on HXT_TIMECARDS_X

Line 281: FROM hxt_timecards_x

277: SELECT assignment_number
278: INTO l_assignment_no
279: FROM per_all_assignments_f
280: WHERE person_id = (SELECT for_person_id
281: FROM hxt_timecards_x
282: WHERE id = p_merge_batches(l_loop_index1).tc_id
283: )
284: AND sysdate between effective_start_date and effective_end_date;
285:

Line 290: FROM hxt_timecards_x tc

286: SELECT pbh.batch_name
287: INTO l_parent_batch_name
288: FROM pay_batch_headers pbh
289: WHERE pbh.batch_id = (SELECT tc.batch_id
290: FROM hxt_timecards_x tc
291: WHERE tc.id = p_merge_batches(l_loop_index1).tc_id
292: );
293:
294: EXCEPTION

Line 387: FROM hxt_timecards_x tim --SIR017

383: AND (pbh.batch_reference LIKE nvl(c_reference_num , '%')
384: OR (pbh.batch_reference IS NULL
385: AND c_reference_num IS NULL))
386: AND exists (SELECT 'x'
387: FROM hxt_timecards_x tim --SIR017
388: WHERE tim.batch_id = pbh.batch_id
389: ) --bug 5748118
390: AND pbh.batch_status = 'U' ; --bug 2709527
391: --

Line 1862: FROM HXT_TIMECARDS_X

1858: , p_TYPE IN VARCHAR2) IS --HXT11i1
1859: CURSOR tim_dates is
1860: SELECT effective_start_date,
1861: effective_end_date
1862: FROM HXT_TIMECARDS_X
1863: WHERE id = p_tim_id;
1864: l_eff_start DATE;
1865: l_eff_end DATE;
1866: BEGIN