APPS.OKL_COPY_CONTRACT_PVT dependencies on FND_LANGUAGES

Line 9015: fnd_languages d

9011: --avsingh: Bug 5710213: end
9012: FROM okc_k_lines_tl a,
9013: okc_k_lines_b b,
9014: okl_k_lines c,
9015: fnd_languages d
9016: --avsingh: Bug 5710213: start
9017: , okc_line_styles_b lsb
9018: --avsingh: Bug 5710213: end
9019: WHERE a.id = b.id

Line 9033: FROM fnd_languages

9029:
9030:
9031: CURSOR c6 IS
9032: SELECT language_code
9033: FROM fnd_languages
9034: WHERE installed_flag IN ('B', 'I');
9035:
9036: CURSOR c7(p_id NUMBER) IS
9037: SELECT DISTINCT a.name

Line 18114: FROM fnd_languages

18110:
18111:
18112: CURSOR c_base_language IS
18113: SELECT language_code
18114: FROM fnd_languages
18115: WHERE installed_flag = 'B';
18116:
18117: CURSOR c_languages IS
18118: SELECT language_code

Line 18119: FROM fnd_languages

18115: WHERE installed_flag = 'B';
18116:
18117: CURSOR c_languages IS
18118: SELECT language_code
18119: FROM fnd_languages
18120: WHERE installed_flag IN ('B','I');
18121:
18122: -- Bug# 5591618
18123: /*

Line 18142: --fnd_languages b

18138: /*
18139: --CURSOR c_try_id IS
18140: --SELECT a.id
18141: --FROM okl_trx_types_tl a,
18142: --fnd_languages b
18143: --WHERE a.name = 'Internal Asset Creation'
18144: --AND a.LANGUAGE = b.language_code
18145: --AND b.installed_flag = 'B';
18146: */

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

18198: TYPE l_book_class_type IS TABLE OF fa_book_controls.book_class%TYPE INDEX BY BINARY_INTEGER;
18199: TYPE l_id_type IS TABLE OF okc_k_lines_b.id%TYPE INDEX BY BINARY_INTEGER;
18200: TYPE l_cle_id_type IS TABLE OF okc_k_lines_b.cle_id%TYPE INDEX BY BINARY_INTEGER;
18201:
18202: TYPE l_lang_tab_type IS TABLE OF fnd_languages.language_code%TYPE INDEX BY BINARY_INTEGER;
18203:
18204: l_ID1_tab l_ID1_type;
18205: l_ID2_tab l_ID2_type;
18206: l_NAME_local_tab l_NAME_type;

Line 18305: l_base_language fnd_languages.language_code%TYPE;

18301: l_tl2language_tab l_tllanguage_type;
18302:
18303: l_txl_assets_tl_counter4 NUMBER := 1;
18304: l_lang_tab l_lang_tab_type;
18305: l_base_language fnd_languages.language_code%TYPE;
18306:
18307: l_orig_cost NUMBER;
18308: l_depreciable_cost NUMBER;
18309: l_deprn_rate fa_books.adjusted_rate%TYPE;