APPS.IBY_AR_UTILS dependencies on IBY_FNDCPT_TX_OPERATIONS

Line 748: (p_trxn_extension_id IN iby_fndcpt_tx_operations.trxn_extension_id%TYPE,

744: END get_trxn_ref_number2;
745:
746: -- Return: The Authorization Flag for the given Transaction Extension Id
747: PROCEDURE get_authorization_status
748: (p_trxn_extension_id IN iby_fndcpt_tx_operations.trxn_extension_id%TYPE,
749: x_auth_flag OUT NOCOPY VARCHAR2)
750: IS
751: l_dbg_mod VARCHAR2(100) := 'IBY_AR_UTILS' || '.get_authorization_status';
752:

Line 757: , iby_fndcpt_tx_operations op

753: CURSOR c_auth_status(c_extension_id iby_fndcpt_tx_extensions.trxn_extension_id%TYPE)
754: IS
755: SELECT decode(summ.status, NULL, 'N', 'Y') AUTHORIZED_FLAG
756: FROM iby_trxn_summaries_all summ
757: , iby_fndcpt_tx_operations op
758: WHERE summ.transactionid = op.transactionid
759: AND reqtype = 'ORAPMTREQ'
760: AND status IN(0, 100)
761: AND op.trxn_extension_id = c_extension_id

Line 767: iby_fndcpt_tx_operations op1

763: OR
764: (trxntypeid = 20
765: AND summ.trxnmid = (SELECT MAX(trxnmid)
766: FROM iby_trxn_summaries_all summ1,
767: iby_fndcpt_tx_operations op1
768: WHERE summ1.transactionid = op1.transactionid
769: AND summ1.reqtype = 'ORAPMTREQ'
770: AND summ1.status IN(0, 100)
771: AND summ1.trxntypeid IN(2, 3, 20)