APPS.HXT_RETRO_PROCESS dependencies on HXT_DET_HOURS_WORKED_X

Line 43: hxt_det_hours_worked_x det

39: pbh.object_version_number
40: FROM pay_batch_headers pbh,
41: hxt_batch_states tbs,
42: hxt_timecards_x tim,
43: hxt_det_hours_worked_x det
44: WHERE det.pay_status = 'R'
45: AND tbs.batch_id = det.retro_batch_id
46: AND det.retro_batch_id BETWEEN nvl(c_retro_batch_id,0)
47: AND nvl(c_retro_batch_id,999999999999)

Line 73: FROM hxt_det_hours_worked_x det, hxt_batch_states hbs

69: SELECT pbh.batch_name, pbh.batch_id
70: FROM pay_batch_headers pbh
71: WHERE pbh.business_group_id = p_bus_group_id
72: AND EXISTS (SELECT 'x'
73: FROM hxt_det_hours_worked_x det, hxt_batch_states hbs
74: WHERE hbs.batch_id = pbh.batch_id
75: AND det.retro_batch_id = hbs.batch_id
76: AND hbs.status in ('VE','H','VT','VV','VW'))
77: ORDER BY pbh.batch_id;

Line 89: FROM hxt_det_hours_worked_x det, hxt_batch_states hbs

85: WHERE pbh.business_group_id = p_bus_group_id
86: AND pbh.batch_id BETWEEN p_start
87: AND p_end
88: AND EXISTS (SELECT 'x'
89: FROM hxt_det_hours_worked_x det, hxt_batch_states hbs
90: WHERE hbs.batch_id = pbh.batch_id
91: AND det.retro_batch_id = hbs.batch_id
92: AND hbs.status in ('VE','H','VT','VV','VW'))
93: ORDER BY pbh.batch_id;