APPS.HXT_BATCH_PROCESS dependencies on HXT_TIMECARDS_X

Line 728: FROM hxt_timecards_x

724: SELECT assignment_number
725: INTO l_assignment_no
726: FROM per_all_assignments_f
727: WHERE person_id = (SELECT for_person_id
728: FROM hxt_timecards_x
729: WHERE id = p_merge_batches(l_loop_index1).tc_id
730: )
731: AND sysdate between effective_start_date and effective_end_date;
732:

Line 737: FROM hxt_timecards_x tc

733: SELECT pbh.batch_name
734: INTO l_parent_batch_name
735: FROM pay_batch_headers pbh
736: WHERE pbh.batch_id = (SELECT tc.batch_id
737: FROM hxt_timecards_x tc
738: WHERE tc.id = p_merge_batches(l_loop_index1).tc_id
739: );
740:
741: EXCEPTION

Line 841: FROM hxt_timecards_x tim --SIR017

837: AND (pbh.batch_reference LIKE nvl(c_reference_num , '%')
838: OR (pbh.batch_reference IS NULL
839: AND c_reference_num IS NULL))
840: AND exists (SELECT 'x'
841: FROM hxt_timecards_x tim --SIR017
842: WHERE tim.batch_id = pbh.batch_id
843: ) --bug 5748118
844: AND NOT EXISTS ( SELECT 1
845: FROM hxc_data_sets hds,

Line 3028: FROM HXT_TIMECARDS_X

3024: , p_TYPE IN VARCHAR2) IS --HXT11i1
3025: CURSOR tim_dates is
3026: SELECT effective_start_date,
3027: effective_end_date
3028: FROM HXT_TIMECARDS_X
3029: WHERE id = p_tim_id;
3030: l_eff_start DATE;
3031: l_eff_end DATE;
3032: BEGIN