DBA Data[Home] [Help]

APPS.OKL_ACCOUNTING_UTIL dependencies on OKL_SYS_ACCT_OPTS

Line 636: FROM OKL_SYS_ACCT_OPTS;

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

Line 701: FROM OKL_SYS_ACCT_OPTS;

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

Line 782: FROM OKL_SYS_ACCT_OPTS;

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

Line 1919: FROM OKL_SYS_ACCT_OPTS;

1915: l_sysdate DATE := G_SYSDATE;
1916: BEGIN
1917:
1918: SELECT cc_rounding_rule INTO l_rounding_rule
1919: FROM OKL_SYS_ACCT_OPTS;
1920:
1921: SELECT PRECISION INTO l_precision
1922: FROM fnd_currencies_vl
1923: WHERE currency_code = p_currency_code

Line 1980: FROM OKL_SYS_ACCT_OPTS;

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

Line 3165: l_acct_derv okl_sys_acct_opts.account_derivation%TYPE;

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

Line 3170: FROM okl_sys_acct_opts;

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