APPS.AR_RECEIPT_API_PUB dependencies on IBY_TRXN_SUMMARIES_ALL

Line 3992: FROM iby_trxn_summaries_all summ,

3988:
3989: Begin
3990: SELECT decode(summ.status, NULL, 'N', 'Y') AUTHORIZED_FLAG
3991: into l_auth_flag
3992: FROM iby_trxn_summaries_all summ,
3993: iby_fndcpt_tx_operations op
3994: WHERE summ.transactionid = op.transactionid
3995: AND reqtype = 'ORAPMTREQ'
3996: AND status IN(0, 100)

Line 4001: FROM iby_trxn_summaries_all

3997: AND trxntypeid IN(2, 3, 20)
3998: AND op.trxn_extension_id = p_payment_trxn_extension_id
3999: AND summ.trxnmid =
4000: (SELECT MAX(trxnmid)
4001: FROM iby_trxn_summaries_all
4002: WHERE transactionid = summ.transactionid
4003: AND reqtype = 'ORAPMTREQ'
4004: AND status IN(0, 100)
4005: AND trxntypeid IN(2, 3, 20));