APPS.JA_CN_JE_EXP_PKG dependencies on FND_CURRENCIES_VL

Line 87: l_functional_currency fnd_currencies_vl.NAME%TYPE;

83: l_journal_lines_gbl_tmp_row ja_cn_journal_lines_gt%ROWTYPE;
84: l_sql_stmt VARCHAR2(30000) := '';
85: l_journal_number ja_cn_journal_lines_gt.journal_number%TYPE := '';
86: l_journal_line_number NUMBER := 0;
87: l_functional_currency fnd_currencies_vl.NAME%TYPE;
88:
89: l_start_date DATE;
90: l_end_date DATE;
91: l_current_period GL_PERIOD_STATUSES.Period_Name%TYPE;

Line 205: ' LEFT JOIN fnd_currencies_vl ' ||

201: prefix_a ||
202: '.je_category=' ||
203: prefix_b ||
204: '.JE_CATEGORY_NAME' ||
205: ' LEFT JOIN fnd_currencies_vl ' ||
206: prefix_c || ' ON ' ||
207: prefix_a ||
208: '.currency_code=' ||
209: prefix_c ||

Line 574: SELECT fnd_currencies_vl.NAME

570:
571: CLOSE c_in_closed_periods;
572:
573: --fetch functional currency
574: SELECT fnd_currencies_vl.NAME
575: INTO l_functional_currency
576: FROM fnd_currencies_vl
577: WHERE currency_code =
578: (SELECT currency_code

Line 576: FROM fnd_currencies_vl

572:
573: --fetch functional currency
574: SELECT fnd_currencies_vl.NAME
575: INTO l_functional_currency
576: FROM fnd_currencies_vl
577: WHERE currency_code =
578: (SELECT currency_code
579: FROM gl_ledgers--gl_sets_of_books
580: WHERE ledger_id = p_ledger_id );--set_of_books_id = l_set_of_books_id);