[Home] [Help]
3038: -- for performance reason, replace the above sql to join to base table
3039: -- instead of the view.
3040: SELECT 'Y'
3041: INTO l_exists_auth
3042: FROM IBY_FNDCPT_TX_OPERATIONS o,
3043: IBY_TRXN_SUMMARIES_ALL a
3044: WHERE o.trxn_extension_id = l_trxn_extension_id
3045: AND o.transactionid = a.transactionid
3046: AND a.status=0;