APPS.JA_CN_JE_EXPORT_PKG dependencies on FND_CURRENCIES_VL

Line 94: l_functional_currency fnd_currencies_vl.NAME%TYPE;

90: l_ja_cn_subsidiary_gbl_tmp_row ja_cn_subsidiary_gt%ROWTYPE;
91: lv_sql_stmt VARCHAR2(30000) := '';
92: l_journal_number ja_cn_journal_lines_gt.journal_number%TYPE := '';
93: ln_journal_line_number NUMBER := 0;
94: l_functional_currency fnd_currencies_vl.NAME%TYPE;
95:
96: ld_start_date DATE;
97: ld_end_date DATE;
98: l_current_period GL_PERIOD_STATUSES.Period_Name%TYPE;

Line 535: SELECT fnd_currencies_vl.NAME

531:
532: CLOSE c_in_closed_periods;
533:
534: --fetch functional currency
535: SELECT fnd_currencies_vl.NAME
536: INTO l_functional_currency
537: FROM fnd_currencies_vl
538: WHERE currency_code =
539: (SELECT currency_code

Line 537: FROM fnd_currencies_vl

533:
534: --fetch functional currency
535: SELECT fnd_currencies_vl.NAME
536: INTO l_functional_currency
537: FROM fnd_currencies_vl
538: WHERE currency_code =
539: (SELECT currency_code
540: FROM gl_ledgers
541: WHERE ledger_id = pn_ledger_id );