[Home] [Help]
2906: -- for performance reason, replace the above sql to join to base table
2907: -- instead of the view.
2908: SELECT 'Y'
2909: INTO l_exists_auth
2910: FROM IBY_FNDCPT_TX_OPERATIONS o,
2911: IBY_TRXN_SUMMARIES_ALL a
2912: WHERE o.trxn_extension_id = l_trxn_extension_id
2913: AND o.transactionid = a.transactionid
2914: AND a.status=0;