DBA Data[Home] [Help]

APPS.OKL_SUB_PVT dependencies on FND_CURRENCIES

Line 1686: FROM fnd_currencies curr

1682: p_currency_code IN VARCHAR2) IS
1683:
1684: CURSOR curr_csr (p_currency_code IN varchar2) IS
1685: SELECT 'Y'
1686: FROM fnd_currencies curr
1687: WHERE curr.currency_code = p_currency_code
1688: AND SYSDATE BETWEEN NVL(curr.START_DATE_ACTIVE,SYSDATE) AND NVL(curr.END_DATE_ACTIVE,SYSDATE)
1689: AND NVL(curr.CURRENCY_FLAG,'N') = 'Y'
1690: AND NVL(curr.ENABLED_FLAG,'N') = 'Y';