DBA Data[Home] [Help]

APPS.HXT_RETRO_PROCESS dependencies on PAY_BATCH_HEADERS

Line 40: FROM pay_batch_headers pbh,

36: SELECT distinct(det.retro_batch_id) batch_id,
37: tim.id tim_id,
38: tbs.status batch_status,
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'

Line 70: FROM pay_batch_headers pbh

66: /*
67:
68: cursor c_batch_ranges is
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

Line 84: FROM pay_batch_headers pbh

80: cursor c_batch_ranges (p_start IN NUMBER,
81: p_end IN NUMBER)
82: is
83: SELECT pbh.batch_id
84: FROM pay_batch_headers pbh
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'