APPS.OE_PAYMENT_TRXN_UTIL dependencies on IBY_TRXN_EXT_AUTHS_V

Line 1307: l_approval_code FROM IBY_TRXN_EXT_AUTHS_V

1303:
1304: --bug 5028932
1305: BEGIN
1306: SELECT AUTHORIZATION_CODE into
1307: l_approval_code FROM IBY_TRXN_EXT_AUTHS_V
1308: WHERE TRXN_EXTENSION_ID = p_trxn_extension_id
1309: --12694453 AND INITIATOR_EXTENSION_ID = p_trxn_extension_id; -- bug 9145261/9335940
1310: --ER#16014135 CC Reversal start
1311: AND nvl(authorization_amount,0) > 0

Line 1363: FROM iby_trxn_ext_auths_v

1359: -- effective_auth_amount
1360: BEGIN
1361: SELECT effective_auth_amount
1362: INTO l_effective_auth_amount
1363: FROM iby_trxn_ext_auths_v
1364: WHERE trxn_extension_id = p_trxn_extension_id
1365: --12694453 AND INITIATOR_EXTENSION_ID = p_trxn_extension_id -- bug 9335940/9145261
1366: AND nvl(authorization_amount,0) > 0
1367: AND authorization_status=0;

Line 3043: FROM IBY_TRXN_EXT_AUTHS_V

3039: END IF;
3040: Begin
3041: SELECT nvl(REVERSAL_ALLOWED,'N'), nvl(AUTHORIZATION_AMOUNT,0)
3042: INTO l_reversal_allowed, l_authorized_amt
3043: FROM IBY_TRXN_EXT_AUTHS_V
3044: WHERE TRXN_EXTENSION_ID = l_trxn_extension_id
3045: AND nvl(authorization_amount,0) > 0
3046: AND authorization_status=0;
3047: exception