DBA Data[Home] [Help]

APPS.WSH_UTIL_VALIDATE dependencies on FND_CURRENCIES_VL

Line 953: -- table fnd_currencies_vl. If both values are specified then

949: --========================================================================
950: -- PROCEDURE : Validate_Currency
951: --
952: -- COMMENT : Validates Currency_code and Currency_Name against
953: -- table fnd_currencies_vl. If both values are specified then
954: -- only Currency_code is used. p_amount if specified is
955: -- checked for correct precision
956: -- If p_otm_enabled is 'Y', rounds p_amount using FND precision
957: -- for the input currency

Line 974: FROM fnd_currencies_vl

970: NVL(precision,0),
971: DECODE(INSTR(TO_CHAR(NVL(p_amount,0)),'.'),0,0,
972: LENGTH(TO_CHAR(NVL(p_amount,0)))-
973: INSTR(TO_CHAR(NVL(p_amount,0)),'.'))
974: FROM fnd_currencies_vl
975: WHERE enabled_flag = 'Y'
976: AND name = decode( c_currency_code, null, c_currency_name, name)
977: AND currency_code = nvl( c_currency_code, currency_code)
978: AND trunc(sysdate) between nvl( start_date_active, trunc(sysdate) )