APPS.OKL_ACCOUNTING_UTIL dependencies on FND_CURRENCIES_VL

Line 325: FROM fnd_currencies_vl

321: l_sysdate DATE := G_SYSDATE;
322:
323: CURSOR curr_csr IS
324: SELECT '1'
325: FROM fnd_currencies_vl
326: WHERE currency_code = p_currency_code
327: AND ENABLED_FLAG = 'Y'
328: AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
329: AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line 704: FROM fnd_currencies_vl

700: FROM OKL_SYS_ACCT_OPTS;
701:
702: CURSOR prec_csr IS
703: SELECT PRECISION
704: FROM fnd_currencies_vl
705: WHERE currency_code = p_currency_code
706: AND enabled_flag = 'Y'
707: AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
708: AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line 786: FROM fnd_currencies_vl

782:
783:
784: CURSOR prec_csr IS
785: SELECT PRECISION
786: FROM fnd_currencies_vl
787: WHERE currency_code = p_currency_code
788: AND enabled_flag = 'Y'
789: AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
790: AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line 1920: FROM fnd_currencies_vl

1916: SELECT cc_rounding_rule INTO l_rounding_rule
1917: FROM OKL_SYS_ACCT_OPTS;
1918:
1919: SELECT PRECISION INTO l_precision
1920: FROM fnd_currencies_vl
1921: WHERE currency_code = p_currency_code
1922: AND enabled_flag = 'Y'
1923: AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
1924: AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line 1982: FROM fnd_currencies_vl

1978: FROM OKL_SYS_ACCT_OPTS;
1979:
1980: CURSOR prec_csr IS
1981: SELECT PRECISION
1982: FROM fnd_currencies_vl
1983: WHERE currency_code = p_currency_code
1984: AND enabled_flag = 'Y'
1985: AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
1986: AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);