APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on FND_CURRENCIES

Line 7068: FROM fnd_currencies

7064:
7065: --get currency attributes
7066: CURSOR l_fndcurrency_csr(cp_currency_code IN VARCHAR2) IS
7067: SELECT precision, minimum_accountable_unit
7068: FROM fnd_currencies
7069: WHERE currency_code = cp_currency_code
7070: AND enabled_flag = 'Y'
7071: AND NVL(start_date_active, sysdate) <= sysdate
7072: AND NVL(end_date_active, sysdate) >= sysdate;

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

7166: END IF;
7167:
7168:
7169: OPEN l_fndcurrency_csr(l_get_contractinfo_rec.currency_code);
7170: FETCH l_fndcurrency_csr INTO l_precision, l_minimum_accountable_unit; -- l_minimum_accountable_unit is optional in fnd_currencies
7171: -- but mandatory for tax team
7172: -- check with Nilesh
7173: IF l_fndcurrency_csr%NOTFOUND THEN
7174: -- currency code is invalid

Line 12221: FROM fnd_currencies

12217: WHERE name = 'Invoice-OKL';
12218:
12219: CURSOR l_fndcurrency_csr(cp_currency_code IN VARCHAR2) IS
12220: SELECT precision, minimum_accountable_unit
12221: FROM fnd_currencies
12222: WHERE currency_code = cp_currency_code
12223: AND enabled_flag = 'Y'
12224: AND NVL(start_date_active, sysdate) <= sysdate
12225: AND NVL(end_date_active, sysdate) >= sysdate;

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

12653: END IF;
12654: CLOSE l_racusttrxtypes_csr;
12655:
12656: OPEN l_fndcurrency_csr(l_trx_currency_code);
12657: FETCH l_fndcurrency_csr INTO l_precision, l_minimum_accountable_unit; -- l_minimum_accountable_unit is optional in fnd_currencies
12658: -- but mandatory for tax team
12659: -- check with Nilesh
12660: IF l_fndcurrency_csr%NOTFOUND THEN
12661: OKC_API.set_message( p_app_name => 'OKC',

Line 15825: FROM fnd_currencies

15821:
15822: -- Get currency attributes
15823: CURSOR l_fndcurrency_csr(cp_currency_code IN VARCHAR2) IS
15824: SELECT precision, minimum_accountable_unit
15825: FROM fnd_currencies
15826: WHERE currency_code = cp_currency_code
15827: AND enabled_flag = 'Y'
15828: AND NVL(start_date_active, sysdate) <= sysdate
15829: AND NVL(end_date_active, sysdate) >= sysdate;