DBA Data[Home] [Help]

APPS.OKL_COPY_CONTRACT_PVT dependencies on FND_LANGUAGES

Line 8928: fnd_languages d

8924: --avsingh: Bug 5710213: end
8925: FROM okc_k_lines_tl a,
8926: okc_k_lines_b b,
8927: okl_k_lines c,
8928: fnd_languages d
8929: --avsingh: Bug 5710213: start
8930: , okc_line_styles_b lsb
8931: --avsingh: Bug 5710213: end
8932: WHERE a.id = b.id

Line 8946: FROM fnd_languages

8942:
8943:
8944: CURSOR c6 IS
8945: SELECT language_code
8946: FROM fnd_languages
8947: WHERE installed_flag IN ('B', 'I');
8948:
8949: CURSOR c7(p_id NUMBER) IS
8950: SELECT DISTINCT a.name

Line 17937: FROM fnd_languages

17933:
17934:
17935: CURSOR c_base_language IS
17936: SELECT language_code
17937: FROM fnd_languages
17938: WHERE installed_flag = 'B';
17939:
17940: CURSOR c_languages IS
17941: SELECT language_code

Line 17942: FROM fnd_languages

17938: WHERE installed_flag = 'B';
17939:
17940: CURSOR c_languages IS
17941: SELECT language_code
17942: FROM fnd_languages
17943: WHERE installed_flag IN ('B','I');
17944:
17945: -- Bug# 5591618
17946: /*

Line 17965: --fnd_languages b

17961: /*
17962: --CURSOR c_try_id IS
17963: --SELECT a.id
17964: --FROM okl_trx_types_tl a,
17965: --fnd_languages b
17966: --WHERE a.name = 'Internal Asset Creation'
17967: --AND a.LANGUAGE = b.language_code
17968: --AND b.installed_flag = 'B';
17969: */

Line 18025: TYPE l_lang_tab_type IS TABLE OF fnd_languages.language_code%TYPE INDEX BY BINARY_INTEGER;

18021: TYPE l_book_class_type IS TABLE OF fa_book_controls.book_class%TYPE INDEX BY BINARY_INTEGER;
18022: TYPE l_id_type IS TABLE OF okc_k_lines_b.id%TYPE INDEX BY BINARY_INTEGER;
18023: TYPE l_cle_id_type IS TABLE OF okc_k_lines_b.cle_id%TYPE INDEX BY BINARY_INTEGER;
18024:
18025: TYPE l_lang_tab_type IS TABLE OF fnd_languages.language_code%TYPE INDEX BY BINARY_INTEGER;
18026:
18027: l_ID1_tab l_ID1_type;
18028: l_ID2_tab l_ID2_type;
18029: l_NAME_local_tab l_NAME_type;

Line 18128: l_base_language fnd_languages.language_code%TYPE;

18124: l_tl2language_tab l_tllanguage_type;
18125:
18126: l_txl_assets_tl_counter4 NUMBER := 1;
18127: l_lang_tab l_lang_tab_type;
18128: l_base_language fnd_languages.language_code%TYPE;
18129:
18130: l_orig_cost NUMBER;
18131: l_depreciable_cost NUMBER;
18132: l_deprn_rate fa_books.adjusted_rate%TYPE;