APPS.HXT_UTIL dependencies on HXT_BATCH_STATES

Line 930: hxt_batch_states tbs

926: /*
927: cursor existing_batch is
928: select retro_batch_id, assignment_id
929: from hxt_det_hours_worked det,
930: hxt_batch_states tbs
931: where det.tim_id = p_tim_id
932: and tbs.batch_id=det.retro_batch_id
933: and tbs.status in ('H','VE')
934: and pay_status = 'R';

Line 940: hxt_batch_states tbs,

936:
937: cursor existing_batch is
938: select retro_batch_id, assignment_id, pbh.batch_reference
939: from hxt_det_hours_worked det,
940: hxt_batch_states tbs,
941: pay_batch_headers pbh
942: where det.tim_id = p_tim_id
943: and tbs.batch_id = det.retro_batch_id
944: and tbs.status in ('H','VE')