DBA Data[Home] [Help]

APPS.WSH_UTIL_VALIDATE dependencies on FND_CURRENCIES_VL

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

927: --========================================================================
928: -- PROCEDURE : Validate_Currency
929: --
930: -- COMMENT : Validates Currency_code and Currency_Name against
931: -- table fnd_currencies_vl. If both values are specified then
932: -- only Currency_code is used. p_amount if specified is
933: -- checked for correct precision
934: -- If p_otm_enabled is 'Y', rounds p_amount using FND precision
935: -- for the input currency

Line 952: FROM fnd_currencies_vl

948: NVL(precision,0),
949: DECODE(INSTR(TO_CHAR(NVL(p_amount,0)),'.'),0,0,
950: LENGTH(TO_CHAR(NVL(p_amount,0)))-
951: INSTR(TO_CHAR(NVL(p_amount,0)),'.'))
952: FROM fnd_currencies_vl
953: WHERE enabled_flag = 'Y'
954: AND name = decode( c_currency_code, null, c_currency_name, name)
955: AND currency_code = nvl( c_currency_code, currency_code)
956: AND trunc(sysdate) between nvl( start_date_active, trunc(sysdate) )