DBA Data[Home] [Help]

APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on GL_DAILY_RATES

Line 937: FROM GL_DAILY_RATES

933: c_conversion_date ZX_LINES.currency_conversion_date%TYPE,
934: c_conversion_type ZX_LINES.currency_conversion_type%TYPE)
935: IS
936: SELECT conversion_rate
937: FROM GL_DAILY_RATES
938: WHERE from_currency = c_from_currency
939: AND to_currency = c_to_currency
940: AND conversion_date = trunc(c_conversion_date)
941: AND conversion_type = c_conversion_type;

Line 1088: -- Conversion rate not found in GL_DAILY_RATES

1084: FETCH get_rate_info_csr INTO l_rate;
1085: IF get_rate_info_csr%NOTFOUND THEN
1086: p_return_status := FND_API.G_RET_STS_ERROR;
1087:
1088: -- Conversion rate not found in GL_DAILY_RATES
1089: FND_MESSAGE.SET_NAME('ZX','ZX_ROUND_NO_EXCH_RATE');
1090: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY', p_from_currency);
1091: FND_MESSAGE.SET_TOKEN('TO_CURRENCY', p_to_currency);
1092: FND_MESSAGE.SET_TOKEN('CURRENCY_CONV_DATE', p_conversion_date);