DBA Data[Home] [Help]

APPS.OKL_ACCOUNTING_UTIL dependencies on OKL_SYS_ACCT_OPTS

Line 635: FROM OKL_SYS_ACCT_OPTS;

631:
632: CURSOR set_of_book_id
633: IS
634: SELECT set_of_books_id
635: FROM OKL_SYS_ACCT_OPTS;
636:
637: CURSOR c_ledger_id IS
638: SELECT ledger_id
639: FROM okl_representations_v

Line 700: FROM OKL_SYS_ACCT_OPTS;

696: l_sysdate DATE := G_SYSDATE;
697:
698: CURSOR ael_csr IS
699: SELECT ael_rounding_rule
700: FROM OKL_SYS_ACCT_OPTS;
701:
702: CURSOR prec_csr IS
703: SELECT PRECISION
704: FROM fnd_currencies_vl

Line 781: FROM OKL_SYS_ACCT_OPTS;

777: CURSOR round_csr IS
778: SELECT cc_rounding_rule,
779: ael_rounding_rule,
780: stm_rounding_rule
781: FROM OKL_SYS_ACCT_OPTS;
782:
783:
784: CURSOR prec_csr IS
785: SELECT PRECISION

Line 1917: FROM OKL_SYS_ACCT_OPTS;

1913: l_sysdate DATE := G_SYSDATE;
1914: BEGIN
1915:
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

Line 1978: FROM OKL_SYS_ACCT_OPTS;

1974: l_api_version NUMBER := 1.0;
1975:
1976: CURSOR rnd_rul_csr IS
1977: SELECT cc_rounding_rule
1978: FROM OKL_SYS_ACCT_OPTS;
1979:
1980: CURSOR prec_csr IS
1981: SELECT PRECISION
1982: FROM fnd_currencies_vl

Line 3163: l_acct_derv okl_sys_acct_opts.account_derivation%TYPE;

3159:
3160: FUNCTION get_account_derivation
3161: RETURN VARCHAR2
3162: AS
3163: l_acct_derv okl_sys_acct_opts.account_derivation%TYPE;
3164:
3165: CURSOR get_acct_derivation_csr
3166: IS
3167: SELECT account_derivation

Line 3168: FROM okl_sys_acct_opts;

3164:
3165: CURSOR get_acct_derivation_csr
3166: IS
3167: SELECT account_derivation
3168: FROM okl_sys_acct_opts;
3169: BEGIN
3170: OPEN get_acct_derivation_csr;
3171: FETCH get_acct_derivation_csr INTO l_acct_derv;
3172: CLOSE get_acct_derivation_csr;