DBA Data[Home] [Help]

APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on GL_DAILY_RATES

Line 945: FROM GL_DAILY_RATES

941: c_conversion_date ZX_LINES.currency_conversion_date%TYPE,
942: c_conversion_type ZX_LINES.currency_conversion_type%TYPE)
943: IS
944: SELECT conversion_rate
945: FROM GL_DAILY_RATES
946: WHERE from_currency = c_from_currency
947: AND to_currency = c_to_currency
948: AND conversion_date = trunc(c_conversion_date)
949: AND conversion_type = c_conversion_type;

Line 1096: -- Conversion rate not found in GL_DAILY_RATES

1092: FETCH get_rate_info_csr INTO l_rate;
1093: IF get_rate_info_csr%NOTFOUND THEN
1094: p_return_status := FND_API.G_RET_STS_ERROR;
1095:
1096: -- Conversion rate not found in GL_DAILY_RATES
1097: FND_MESSAGE.SET_NAME('ZX','ZX_ROUND_NO_EXCH_RATE');
1098: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY', p_from_currency);
1099: FND_MESSAGE.SET_TOKEN('TO_CURRENCY', p_to_currency);
1100: FND_MESSAGE.SET_TOKEN('CURRENCY_CONV_DATE', p_conversion_date);