DBA Data[Home] [Help]

APPS.AS_OPP_HEADER_PVT dependencies on FND_CURRENCIES

Line 3399: FROM fnd_currencies

3395: )
3396: IS
3397: CURSOR C_Currency_Exists (c_currency_code VARCHAR2) IS
3398: SELECT 'X'
3399: FROM fnd_currencies
3400: WHERE currency_code = c_currency_code
3401: -- ffang 091200 for bug 1403865
3402: and nvl(start_date_active, sysdate) <= sysdate
3403: and nvl(end_date_active, sysdate) >= sysdate

Line 3426: -- CURRENCY_CODE should exist in fnd_currencies_vl

3422:
3423: IF (p_CURRENCY_CODE is NOT NULL) and
3424: (p_CURRENCY_CODE <> FND_API.G_MISS_CHAR)
3425: THEN
3426: -- CURRENCY_CODE should exist in fnd_currencies_vl
3427: OPEN C_Currency_Exists (p_CURRENCY_CODE);
3428: FETCH C_Currency_Exists into l_val;
3429:
3430: IF C_Currency_Exists%NOTFOUND THEN