DBA Data[Home] [Help]

APPS.JA_CN_EAB_EXPORT_PKG dependencies on GL_LEDGERS

Line 32: g_ledger_id GL_LEDGERS.Ledger_Id%TYPE;

28: g_module_name VARCHAR2(30) := 'JA_CN_EAB_EXPORT_PKG';
29: g_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
30: g_proc_level NUMBER := FND_LOG.Level_Procedure;
31: g_stmt_level NUMBER := FND_LOG.Level_Statement;
32: g_ledger_id GL_LEDGERS.Ledger_Id%TYPE;
33: g_book_num JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NUM%TYPE;
34: g_book_name JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NAME%TYPE;
35: g_company_name JA_CN_SYSTEM_PARAMETERS_ALL.COMPANY_NAME%TYPE;
36: g_organization_id JA_CN_SYSTEM_PARAMETERS_ALL.ORGANIZATION_ID%TYPE;

Line 287: FROM Gl_LEDGERS ledger, FND_CURRENCIES_TL fct

283:
284: -- the sql is used to get functional_currency
285: SELECT fct.NAME
286: INTO g_functional_currency
287: FROM Gl_LEDGERS ledger, FND_CURRENCIES_TL fct
288: WHERE ledger.currency_code = fct.currency_code
289: AND fct.LANGUAGE = userenv('lang')
290: AND ledger.ledger_id = P_LEDGER_ID;
291: