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 1047: FROM OKL_SYS_ACCT_OPTS;

1043:
1044: CURSOR get_rounding_rule
1045: IS
1046: SELECT stm_rounding_rule
1047: FROM OKL_SYS_ACCT_OPTS;
1048:
1049: CURSOR get_rnd_diff_lookup(p_lookup_type fnd_lookups.lookup_type%TYPE)
1050: IS
1051: SELECT b.stm_apply_rounding_difference

Line 1053: OKL_SYS_ACCT_OPTS b

1049: CURSOR get_rnd_diff_lookup(p_lookup_type fnd_lookups.lookup_type%TYPE)
1050: IS
1051: SELECT b.stm_apply_rounding_difference
1052: FROM fnd_lookups a,
1053: OKL_SYS_ACCT_OPTS b
1054: WHERE a.lookup_type = p_lookup_type
1055: AND a.lookup_code = b.stm_apply_rounding_difference;
1056:
1057: --Added by KTHIRUVA for ESG Performance Imporvement on 03-May-2005

Line 1077: l_rounding_rule okl_sys_acct_opts.ael_rounding_rule%TYPE;

1073: l_org_id okc_k_headers_b.authoring_org_id%TYPE;
1074: l_currency_code okc_k_headers_b.currency_code%TYPE;
1075: l_diff_lookup_code fnd_lookups.lookup_code%TYPE;
1076: l_precision NUMBER;
1077: l_rounding_rule okl_sys_acct_opts.ael_rounding_rule%TYPE;
1078: l_first_rec CHAR := 'T';
1079:
1080: G_RND_DIFF_LOOKUP_TYPE CONSTANT fnd_lookups.lookup_type%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';
1081: G_NO_MATCH_REC CONSTANT VARCHAR2(30) := 'OKL_LLA_NO_MATCHING_RECORD';