DBA Data[Home] [Help]

APPS.OE_PAYMENT_TRXN_UTIL dependencies on IBY_TRXN_EXT_AUTHS_V

Line 1116: l_approval_code FROM IBY_TRXN_EXT_AUTHS_V

1112:
1113: --bug 5028932
1114: BEGIN
1115: SELECT AUTHORIZATION_CODE into
1116: l_approval_code FROM IBY_TRXN_EXT_AUTHS_V
1117: WHERE TRXN_EXTENSION_ID = p_trxn_extension_id;
1118: EXCEPTION
1119: WHEN OTHERS THEN
1120: l_approval_code := null;

Line 1158: FROM iby_trxn_ext_auths_v

1154: -- effective_auth_amount
1155: BEGIN
1156: SELECT effective_auth_amount
1157: INTO l_effective_auth_amount
1158: FROM iby_trxn_ext_auths_v
1159: WHERE trxn_extension_id = p_trxn_extension_id
1160: AND nvl(authorization_amount,0) > 0
1161: AND authorization_status=0;
1162: EXCEPTION WHEN NO_DATA_FOUND THEN