DBA Data[Home] [Help]

APPS.OKL_PROCESS_STREAMS_PVT dependencies on FND_LOOKUPS

Line 996: CURSOR get_rnd_diff_lookup(p_lookup_type fnd_lookups.lookup_type%TYPE)

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
999: FROM fnd_lookups a,
1000: OKL_SYS_ACCT_OPTS b

Line 999: FROM fnd_lookups a,

995:
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:

Line 1022: l_diff_lookup_code fnd_lookups.lookup_code%TYPE;

1018: --Bug 4346646 - End of Changes
1019:
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:

Line 1027: G_RND_DIFF_LOOKUP_TYPE CONSTANT fnd_lookups.lookup_type%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';

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';
1029: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
1030: -- Bug 4196515: End
1031: