APPS.JA_CN_APAB_EXPORT_PKG dependencies on FND_CURRENCIES_VL

Line 77: l_functional_currency fnd_currencies_vl.NAME%TYPE;

73: lv_dr_cr_begin FND_LOOKUP_VALUES.MEANING%TYPE;
74: lv_dr_cr_end FND_LOOKUP_VALUES.MEANING%TYPE;
75: lv_message VARCHAR2(300);
76:
77: l_functional_currency fnd_currencies_vl.NAME%TYPE;
78: l_functional_currency_code fnd_currencies_vl.CURRENCY_CODE%TYPE;
79: ln_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
80: l_ja_cn_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;
81: l_context_code ja_cn_dff_assignments.context_code%TYPE;

Line 78: l_functional_currency_code fnd_currencies_vl.CURRENCY_CODE%TYPE;

74: lv_dr_cr_end FND_LOOKUP_VALUES.MEANING%TYPE;
75: lv_message VARCHAR2(300);
76:
77: l_functional_currency fnd_currencies_vl.NAME%TYPE;
78: l_functional_currency_code fnd_currencies_vl.CURRENCY_CODE%TYPE;
79: ln_flex_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
80: l_ja_cn_dff_assignments_row ja_cn_dff_assignments%ROWTYPE;
81: l_context_code ja_cn_dff_assignments.context_code%TYPE;
82: l_attribute_column4balanceside ja_cn_dff_assignments.attribute_column%TYPE;

Line 449: SELECT fnd_currencies_vl.NAME

445: END IF; --c_in_ja_cn_account_balances%ROWCOUNT = 0
446: CLOSE c_in_ja_cn_account_balances;
447:
448: --Fetch functional currency name
449: SELECT fnd_currencies_vl.NAME
450: INTO l_functional_currency
451: FROM fnd_currencies_vl
452: WHERE currency_code =
453: (SELECT currency_code

Line 451: FROM fnd_currencies_vl

447:
448: --Fetch functional currency name
449: SELECT fnd_currencies_vl.NAME
450: INTO l_functional_currency
451: FROM fnd_currencies_vl
452: WHERE currency_code =
453: (SELECT currency_code
454: FROM gl_ledgers
455: WHERE ledger_id = pn_ledger_id);