1219:
1220: Begin
1221: SELECT decode(summ.status, NULL, 'N', 'Y') AUTHORIZED_FLAG
1222: into l_auth_flag
1223: FROM iby_trxn_summaries_all summ,
1224: iby_fndcpt_tx_operations op
1225: WHERE summ.transactionid = op.transactionid
1226: AND reqtype = 'ORAPMTREQ'
1227: AND status IN(0, 100)
1228: AND trxntypeid IN(2, 3, 20)
1229: AND op.trxn_extension_id = l_trxn_entity_id
1230: AND summ.trxnmid =
1231: (SELECT MAX(trxnmid)
1232: FROM iby_trxn_summaries_all
1233: WHERE transactionid = summ.transactionid
1234: AND reqtype = 'ORAPMTREQ'
1235: AND status IN(0, 100)
1236: AND trxntypeid IN(2, 3, 20));