540:
541: Begin
542: SELECT decode(summ.status, NULL, 'N', 'Y') AUTHORIZED_FLAG
543: into l_auth_flag
544: FROM iby_trxn_summaries_all summ,
545: iby_fndcpt_tx_operations op
546: WHERE summ.transactionid = op.transactionid
547: AND reqtype = 'ORAPMTREQ'
548: AND status IN(0, 100)
549: AND trxntypeid IN(2, 3, 20)
550: AND op.trxn_extension_id = l_trxn_entity_id
551: AND summ.trxnmid =
552: (SELECT MAX(trxnmid)
553: FROM iby_trxn_summaries_all
554: WHERE transactionid = summ.transactionid
555: AND reqtype = 'ORAPMTREQ'
556: AND status IN(0, 100)
557: AND trxntypeid IN(2, 3, 20));