APPS.AR_RECEIPT_API_PUB dependencies on IBY_TRXN_SUMMARIES_ALL

Line 3935: FROM iby_trxn_summaries_all summ,

3931:
3932: Begin
3933: SELECT decode(summ.status, NULL, 'N', 'Y') AUTHORIZED_FLAG
3934: into l_auth_flag
3935: FROM iby_trxn_summaries_all summ,
3936: iby_fndcpt_tx_operations op
3937: WHERE summ.transactionid = op.transactionid
3938: AND reqtype = 'ORAPMTREQ'
3939: AND status IN(0, 100)

Line 3944: FROM iby_trxn_summaries_all

3940: AND trxntypeid IN(2, 3, 20)
3941: AND op.trxn_extension_id = p_payment_trxn_extension_id
3942: AND summ.trxnmid =
3943: (SELECT MAX(trxnmid)
3944: FROM iby_trxn_summaries_all
3945: WHERE transactionid = summ.transactionid
3946: AND reqtype = 'ORAPMTREQ'
3947: AND status IN(0, 100)
3948: AND trxntypeid IN(2, 3, 20));