APPS.HXT_RETRO_PROCESS dependencies on HXT_BATCH_STATES

Line 35: hxt_batch_states tbs,

31: tim.id tim_id,
32: tbs.status batch_status,
33: pbh.object_version_number
34: FROM pay_batch_headers pbh,
35: hxt_batch_states tbs,
36: hxt_timecards_x tim,
37: hxt_det_hours_worked_x det
38: WHERE det.pay_status = 'R'
39: AND tbs.batch_id = det.retro_batch_id

Line 58: FROM hxt_det_hours_worked_x det, hxt_batch_states hbs

54: SELECT pbh.batch_name, pbh.batch_id
55: FROM pay_batch_headers pbh
56: WHERE pbh.business_group_id = p_bus_group_id
57: AND EXISTS (SELECT 'x'
58: FROM hxt_det_hours_worked_x det, hxt_batch_states hbs
59: WHERE hbs.batch_id = pbh.batch_id
60: AND det.retro_batch_id = hbs.batch_id
61: AND hbs.status in ('VE','H','VT','VV','VW'))
62: ORDER BY pbh.batch_id;