APPS.HXC_RETRIEVAL_ROLLBACK dependencies on PAY_BATCH_HEADERS

Line 119: FROM pay_batch_headers

115:
116: CURSOR get_batch_name
117: IS SELECT batch_name,
118: batch_status
119: FROM pay_batch_headers
120: WHERE batch_id = p_batch_id;
121:
122: l_batch_name VARCHAR2(40);
123: l_batch_status VARCHAR2(10);

Line 167: FROM pay_batch_headers

163:
164: CURSOR get_batch_name
165: IS SELECT batch_name,
166: batch_status
167: FROM pay_batch_headers
168: WHERE batch_id = p_batch_id;
169:
170: l_batch_name VARCHAR2(40);
171: l_batch_status VARCHAR2(10);

Line 1168: FROM pay_batch_headers

1164: l_lines NUMTAB;
1165:
1166: CURSOR get_batch_status
1167: IS SELECT batch_status
1168: FROM pay_batch_headers
1169: WHERE batch_id = p_batch_id;
1170: /*
1171: CURSOR get_lines
1172: IS SELECT batch_line_id,

Line 3270: FROM pay_batch_headers

3266: AND batch_id IS NOT NULL;
3267:
3268: CURSOR get_batches_ref(p_batch_ref IN VARCHAR2)
3269: IS SELECT batch_id
3270: FROM pay_batch_headers
3271: WHERE batch_reference = p_batch_ref;
3272:
3273: l_x_batches NUMTAB := NUMTAB();
3274: l_r_batches NUMTAB := NUMTAB();