APPS.OKL_PROCESS_STREAMS_PVT dependencies on OKL_SYS_ACCT_OPTS

Line 43: FROM OKL_SYS_ACCT_OPTS;

39: -- modify this parameter to apply rounding to the amount
40: l_apply_rounding_rule BOOLEAN := FALSE;
41: CURSOR rule_cur IS
42: SELECT ael_rounding_rule
43: FROM OKL_SYS_ACCT_OPTS;
44: CURSOR currency_cur IS
45: SELECT currency_code
46: FROM okc_k_headers_v
47: WHERE id = p_contract_id;

Line 994: FROM OKL_SYS_ACCT_OPTS;

990:
991: CURSOR get_rounding_rule
992: IS
993: SELECT stm_rounding_rule
994: FROM OKL_SYS_ACCT_OPTS;
995:
996: CURSOR get_rnd_diff_lookup(p_lookup_type fnd_lookups.lookup_type%TYPE)
997: IS
998: SELECT b.stm_apply_rounding_difference

Line 1000: OKL_SYS_ACCT_OPTS b

996: CURSOR get_rnd_diff_lookup(p_lookup_type fnd_lookups.lookup_type%TYPE)
997: IS
998: SELECT b.stm_apply_rounding_difference
999: FROM fnd_lookups a,
1000: OKL_SYS_ACCT_OPTS b
1001: WHERE a.lookup_type = p_lookup_type
1002: AND a.lookup_code = b.stm_apply_rounding_difference;
1003:
1004: --Added by KTHIRUVA for ESG Performance Imporvement on 03-May-2005

Line 1024: l_rounding_rule okl_sys_acct_opts.ael_rounding_rule%TYPE;

1020: l_org_id okc_k_headers_b.authoring_org_id%TYPE;
1021: l_currency_code okc_k_headers_b.currency_code%TYPE;
1022: l_diff_lookup_code fnd_lookups.lookup_code%TYPE;
1023: l_precision NUMBER;
1024: l_rounding_rule okl_sys_acct_opts.ael_rounding_rule%TYPE;
1025: l_first_rec CHAR := 'T';
1026:
1027: G_RND_DIFF_LOOKUP_TYPE CONSTANT fnd_lookups.lookup_type%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';
1028: G_NO_MATCH_REC CONSTANT VARCHAR2(30) := 'OKL_LLA_NO_MATCHING_RECORD';