APPS.CE_PMT_CALLOUT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

	SELECT docs.calling_app_doc_ref_number
	FROM iby_fd_docs_payable_v docs
	WHERE docs.rejected_docs_group_id = cs_rejected_docs_group_id;

Line: 29

		UPDATE ce_payment_transactions
		SET		trxn_status_code = 'FAILED'
		WHERE 	trxn_reference_number = l_trxn_reference_number;

Line: 53

	SELECT docs.calling_app_doc_ref_number,
	       pmts.payment_reference_number
	FROM iby_fd_docs_payable_v docs,
	     iby_fd_payments_v pmts
	WHERE docs.completed_pmts_group_id = cs_completed_pmts_group_id
	AND   docs.payment_id = pmts.payment_id;

Line: 98

	SELECT docs.calling_app_doc_ref_number
	FROM iby_fd_docs_payable_v docs
	WHERE docs.payment_id = cs_payment_id;

Line: 112

		UPDATE ce_payment_transactions
		SET trxn_status_code = 'CANCELED'
		WHERE trxn_reference_number = l_trxn_reference_number;