APPS.HXT_RETRO_PROCESS dependencies on PAY_BATCH_HEADERS

Line 34: FROM pay_batch_headers pbh,

30: SELECT distinct(det.retro_batch_id) batch_id,
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'

Line 55: FROM pay_batch_headers pbh

51: -- v115.11 start
52: -- Adding cursor to retrieve all valid batch ranges.
53: cursor c_batch_ranges is
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