APPS.CSE_IPV_FA_PKG dependencies on CSI_TXN_ERRORS

Line 56: from csi_txn_errors

52: where request_id = cp_conc_request_id ;
53:
54: Cursor c_failed_count( cp_conc_request_id NUMBER ) IS
55: select count(1 ) failed_count
56: from csi_txn_errors
57: where source_group_ref_id=cp_conc_request_id ;
58:
59: Cursor c_Exceptions( cp_conc_request_id NUMBER ) IS
60: select aia.invoice_num invoice_number,

Line 67: csi_txn_errors cte

63: aida.base_invoice_price_variance base_invoice_price_variance,
64: cte.error_text error_text
65: from ap_invoices_all aia,
66: ap_invoice_distributions_all aida,
67: csi_txn_errors cte
68: where aida.invoice_id = aia.invoice_id
69: and cte.source_id = aida.invoice_distribution_id
70: and cte.source_group_ref_id = cp_conc_request_id ;
71: