APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on FND_CURRENCIES

Line 7099: FROM fnd_currencies

7095:
7096: --get currency attributes
7097: CURSOR l_fndcurrency_csr(cp_currency_code IN VARCHAR2) IS
7098: SELECT precision, minimum_accountable_unit
7099: FROM fnd_currencies
7100: WHERE currency_code = cp_currency_code
7101: AND enabled_flag = 'Y'
7102: AND NVL(start_date_active, sysdate) <= sysdate
7103: AND NVL(end_date_active, sysdate) >= sysdate;

Line 7201: FETCH l_fndcurrency_csr INTO l_precision, l_minimum_accountable_unit; -- l_minimum_accountable_unit is optional in fnd_currencies

7197: END IF;
7198:
7199:
7200: OPEN l_fndcurrency_csr(l_get_contractinfo_rec.currency_code);
7201: FETCH l_fndcurrency_csr INTO l_precision, l_minimum_accountable_unit; -- l_minimum_accountable_unit is optional in fnd_currencies
7202: -- but mandatory for tax team
7203: -- check with Nilesh
7204: IF l_fndcurrency_csr%NOTFOUND THEN
7205: -- currency code is invalid

Line 12256: FROM fnd_currencies

12252: WHERE name = 'Invoice-OKL';
12253:
12254: CURSOR l_fndcurrency_csr(cp_currency_code IN VARCHAR2) IS
12255: SELECT precision, minimum_accountable_unit
12256: FROM fnd_currencies
12257: WHERE currency_code = cp_currency_code
12258: AND enabled_flag = 'Y'
12259: AND NVL(start_date_active, sysdate) <= sysdate
12260: AND NVL(end_date_active, sysdate) >= sysdate;

Line 12692: FETCH l_fndcurrency_csr INTO l_precision, l_minimum_accountable_unit; -- l_minimum_accountable_unit is optional in fnd_currencies

12688: END IF;
12689: CLOSE l_racusttrxtypes_csr;
12690:
12691: OPEN l_fndcurrency_csr(l_trx_currency_code);
12692: FETCH l_fndcurrency_csr INTO l_precision, l_minimum_accountable_unit; -- l_minimum_accountable_unit is optional in fnd_currencies
12693: -- but mandatory for tax team
12694: -- check with Nilesh
12695: IF l_fndcurrency_csr%NOTFOUND THEN
12696: OKC_API.set_message( p_app_name => 'OKC',

Line 15897: FROM fnd_currencies

15893:
15894: -- Get currency attributes
15895: CURSOR l_fndcurrency_csr(cp_currency_code IN VARCHAR2) IS
15896: SELECT precision, minimum_accountable_unit
15897: FROM fnd_currencies
15898: WHERE currency_code = cp_currency_code
15899: AND enabled_flag = 'Y'
15900: AND NVL(start_date_active, sysdate) <= sysdate
15901: AND NVL(end_date_active, sysdate) >= sysdate;