DBA Data[Home] [Help]

APPS.HXC_RETRIEVAL_ROLLBACK dependencies on HXC_PAY_TRANS_CODE_ALL

Line 3258: FROM hxc_pay_trans_code_all

3254: -- Added the NOT NULL condition to avoid picking up OTLR
3255: -- records with NULL batches.
3256: CURSOR get_batches_x_code(p_trans_code IN VARCHAR2)
3257: IS SELECT batch_id
3258: FROM hxc_pay_trans_code_all
3259: WHERE transaction_code = p_trans_code
3260: AND batch_id IS NOT NULL;
3261:
3262: CURSOR get_batches_request(p_request_id IN NUMBER)

Line 3264: FROM hxc_pay_trans_code_all

3260: AND batch_id IS NOT NULL;
3261:
3262: CURSOR get_batches_request(p_request_id IN NUMBER)
3263: IS SELECT batch_id
3264: FROM hxc_pay_trans_code_all
3265: WHERE request_id = p_request_id
3266: AND batch_id IS NOT NULL;
3267:
3268: CURSOR get_batches_ref(p_batch_ref IN VARCHAR2)