APPS.OE_VERIFY_PAYMENT_PUB dependencies on IBY_TRXN_EXT_AUTHS_V

Line 5474: FROM iby_trxn_ext_auths_v

5470:
5471: BEGIN
5472: SELECT 'Y'
5473: INTO l_auth_exists
5474: FROM iby_trxn_ext_auths_v
5475: WHERE trxn_extension_id = l_payments_tbl(I).trxn_extension_id
5476: AND nvl(authorization_amount,0) > 0
5477: AND authorization_status=0;
5478: EXCEPTION

Line 6098: FROM iby_trxn_ext_auths_v

6094: END IF;
6095: Begin
6096: SELECT nvl(AUTHORIZATION_AMOUNT,0)
6097: INTO l_authorized_amt
6098: FROM iby_trxn_ext_auths_v
6099: WHERE trxn_extension_id = l_trxn_extension_id
6100: AND nvl(authorization_amount,0) > 0
6101: AND authorization_status=0 ;
6102: exception

Line 7001: FROM iby_trxn_ext_auths_v

6997: -- effective_auth_amount
6998: BEGIN
6999: SELECT effective_auth_amount
7000: INTO l_effective_auth_amount
7001: FROM iby_trxn_ext_auths_v
7002: WHERE trxn_extension_id = p_trxn_extension_id
7003: --12694453 AND INITIATOR_EXTENSION_ID = p_trxn_extension_id -- bug 9335940 /9145261
7004: AND nvl(authorization_amount,0) > 0
7005: AND authorization_status=0;

Line 7123: FROM iby_trxn_ext_auths_v

7119: END IF;
7120: BEGIN
7121: SELECT nvl(REVERSAL_ALLOWED,'N'), nvl(AUTHORIZATION_AMOUNT,0)
7122: INTO l_reversal_allowed, l_authorized_amt
7123: FROM iby_trxn_ext_auths_v
7124: WHERE trxn_extension_id = p_trxn_extension_id
7125: AND nvl(authorization_amount,0) > 0
7126: AND authorization_status=0 ;
7127: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 7225: FROM iby_trxn_ext_auths_v

7221: p_reauthorize_out := l_reauthorize_flag ;
7222: BEGIN
7223: SELECT nvl(REVERSAL_ALLOWED,'N')
7224: INTO l_reversal_allowed
7225: FROM iby_trxn_ext_auths_v
7226: WHERE trxn_extension_id = p_trxn_extension_id
7227: AND nvl(authorization_amount,0) > 0
7228: AND authorization_status=0 ;
7229: EXCEPTION WHEN NO_DATA_FOUND THEN