APPS.JMF_SHIKYU_RPT_CFR_PVT dependencies on GL_LEDGERS

Line 257: l_functional_currency gl_ledgers.currency_code%TYPE;

253: l_currency_conversion_date DATE;
254: --for checking SHIKYU enable profile.
255: l_jmf_shk_not_enabled VARCHAR2(240);
256: l_conc_succ BOOLEAN;
257: l_functional_currency gl_ledgers.currency_code%TYPE;
258:
259: -- Bug 5665334
260: l_oem_inv_org_name_from hr_all_organization_units_tl.name%TYPE := NULL;
261: l_oem_inv_org_name_to hr_all_organization_units_tl.name%TYPE := NULL;

Line 320: SELECT gl_ledgers.currency_code

316:
317: l_functional_currency := p_functional_currency;
318: IF (p_functional_currency IS NULL)
319: THEN
320: SELECT gl_ledgers.currency_code
321: INTO l_functional_currency
322: FROM gl_ledgers gl_ledgers
323: WHERE gl_ledgers.ledger_id =
324: /* (SELECT DISTINCT xllv.ledger_id

Line 322: FROM gl_ledgers gl_ledgers

318: IF (p_functional_currency IS NULL)
319: THEN
320: SELECT gl_ledgers.currency_code
321: INTO l_functional_currency
322: FROM gl_ledgers gl_ledgers
323: WHERE gl_ledgers.ledger_id =
324: /* (SELECT DISTINCT xllv.ledger_id
325: FROM xle_le_ou_ledger_v xllv
326: WHERE xllv.operating_unit_id = p_ou_id

Line 323: WHERE gl_ledgers.ledger_id =

319: THEN
320: SELECT gl_ledgers.currency_code
321: INTO l_functional_currency
322: FROM gl_ledgers gl_ledgers
323: WHERE gl_ledgers.ledger_id =
324: /* (SELECT DISTINCT xllv.ledger_id
325: FROM xle_le_ou_ledger_v xllv
326: WHERE xllv.operating_unit_id = p_ou_id
327: );*/