APPS.HXT_RETRO_PROCESS dependencies on HXT_DET_HOURS_WORKED_X

Line 37: hxt_det_hours_worked_x det

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
40: AND det.retro_batch_id BETWEEN nvl(c_retro_batch_id,0)
41: AND nvl(c_retro_batch_id,999999999999)

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;