eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_PLSQL_CACHE_PKG dependencies on GL_LEDGERS

Line 6: ledger_id GL_LEDGERS.ledger_id%TYPE , -- SOB

2: /* $Header: jai_plsql_cache.pls 120.3 2006/05/26 11:36:23 lgopalsa noship $ */
3:
4: TYPE func_curr_details IS RECORD
5: ( --organization_id HR_ALL_ORGANIZATION_UNITS.organization_id%TYPE, -- org id
6: ledger_id GL_LEDGERS.ledger_id%TYPE , -- SOB
7: currency_code GL_LEDGERS.currency_code%TYPE ,
8: chart_of_accounts_id GL_LEDGERS.chart_of_accounts_id%TYPE,
9: organization_code MTL_PARAMETERS.organization_code%TYPE,
10: legal_entity HR_ORGANIZATION_INFORMATION.org_information2%TYPE,

Line 7: currency_code GL_LEDGERS.currency_code%TYPE ,

3:
4: TYPE func_curr_details IS RECORD
5: ( --organization_id HR_ALL_ORGANIZATION_UNITS.organization_id%TYPE, -- org id
6: ledger_id GL_LEDGERS.ledger_id%TYPE , -- SOB
7: currency_code GL_LEDGERS.currency_code%TYPE ,
8: chart_of_accounts_id GL_LEDGERS.chart_of_accounts_id%TYPE,
9: organization_code MTL_PARAMETERS.organization_code%TYPE,
10: legal_entity HR_ORGANIZATION_INFORMATION.org_information2%TYPE,
11: organization_name HR_ALL_ORGANIZATION_UNITS.name%TYPE,

Line 8: chart_of_accounts_id GL_LEDGERS.chart_of_accounts_id%TYPE,

4: TYPE func_curr_details IS RECORD
5: ( --organization_id HR_ALL_ORGANIZATION_UNITS.organization_id%TYPE, -- org id
6: ledger_id GL_LEDGERS.ledger_id%TYPE , -- SOB
7: currency_code GL_LEDGERS.currency_code%TYPE ,
8: chart_of_accounts_id GL_LEDGERS.chart_of_accounts_id%TYPE,
9: organization_code MTL_PARAMETERS.organization_code%TYPE,
10: legal_entity HR_ORGANIZATION_INFORMATION.org_information2%TYPE,
11: organization_name HR_ALL_ORGANIZATION_UNITS.name%TYPE,
12: -- Bug 5243532. Added by Lakshmi Gopalsami

Line 43: (cp_ledger_id IN GL_LEDGERS.ledger_id%TYPE) IS

39: WHERE organization_id = cp_org_id;
40:
41:
42: CURSOR get_func_curr
43: (cp_ledger_id IN GL_LEDGERS.ledger_id%TYPE) IS
44: SELECT currency_code curr_code,
45: chart_of_accounts_id coa
46: FROM gl_ledgers
47: WHERE ledger_id = cp_ledger_id;

Line 46: FROM gl_ledgers

42: CURSOR get_func_curr
43: (cp_ledger_id IN GL_LEDGERS.ledger_id%TYPE) IS
44: SELECT currency_code curr_code,
45: chart_of_accounts_id coa
46: FROM gl_ledgers
47: WHERE ledger_id = cp_ledger_id;
48:
49: /* Bug 5243532. Added by Lakshmi Gopalsami */
50: /* Currency precision details */