APPS.AR_PREPAYMENTS_PUB dependencies on IBY_TRXN_SUMMARIES_ALL

Line 533: FROM iby_trxn_summaries_all summ,

529:
530: Begin
531: SELECT decode(summ.status, NULL, 'N', 'Y') AUTHORIZED_FLAG
532: into l_auth_flag
533: FROM iby_trxn_summaries_all summ,
534: iby_fndcpt_tx_operations op
535: WHERE summ.transactionid = op.transactionid
536: AND reqtype = 'ORAPMTREQ'
537: AND status IN(0, 100)

Line 542: FROM iby_trxn_summaries_all

538: AND trxntypeid IN(2, 3, 20)
539: AND op.trxn_extension_id = l_trxn_entity_id
540: AND summ.trxnmid =
541: (SELECT MAX(trxnmid)
542: FROM iby_trxn_summaries_all
543: WHERE transactionid = summ.transactionid
544: AND reqtype = 'ORAPMTREQ'
545: AND status IN(0, 100)
546: AND trxntypeid IN(2, 3, 20));