APPS.HXT_RETRIEVAL_ROLLBACK dependencies on PAY_BATCH_HEADERS

Line 116: FROM pay_batch_headers

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

Line 160: FROM pay_batch_headers

156:
157: CURSOR get_batch_name
158: IS SELECT batch_name,
159: batch_status
160: FROM pay_batch_headers
161: WHERE batch_id = p_batch_id;
162:
163: l_batch_name VARCHAR2(40);
164: l_batch_status VARCHAR2(10);

Line 1431: FROM pay_batch_headers

1427: l_lines NUMTAB;
1428:
1429: CURSOR get_batch_status
1430: IS SELECT batch_status
1431: FROM pay_batch_headers
1432: WHERE batch_id = p_batch_id;
1433: /*
1434:
1435: CURSOR get_lines

Line 1871: FROM pay_batch_headers pbh

1867: IS
1868:
1869: CURSOR get_batch_details(p_batch NUMBER)
1870: IS SELECT object_version_number
1871: FROM pay_batch_headers pbh
1872: WHERE batch_id = p_batch;
1873:
1874: l_ovn NUMBER;
1875:

Line 2282: FROM pay_batch_headers pbh,

2278:
2279: l_sql VARCHAR2(4000) :=
2280: ' SELECT pbh.batch_id,
2281: pbh.batch_status
2282: FROM pay_batch_headers pbh,
2283: hxt_batch_states hbs
2284: WHERE pbh.business_group_id = :bg_id
2285: AND pbh.batch_id = hbs.batch_id
2286: AND hbs.status = ''VT''';

Line 2923: FROM pay_batch_headers pbh,

2919:
2920: l_sql VARCHAR2(4000) :=
2921: ' SELECT pbh.batch_id,
2922: pbh.batch_status
2923: FROM pay_batch_headers pbh,
2924: hxt_batch_states hbs
2925: WHERE pbh.business_group_id = :bg_id
2926: AND pbh.batch_id = hbs.batch_id
2927: AND hbs.status = ''VT''';

Line 3902: FROM pay_batch_headers

3898:
3899:
3900: CURSOR get_batches(p_batch_ref IN VARCHAR2)
3901: IS SELECT batch_id
3902: FROM pay_batch_headers
3903: WHERE batch_reference = p_batch_ref;
3904:
3905:
3906: l_asg_criteria VARCHAR2(4000);