DBA Data[Home] [Help]

APPS.JAI_PLSQL_CACHE_PKG dependencies on FND_CURRENCIES

Line 13: minimum_acct_unit FND_CURRENCIES.minimum_accountable_unit%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
13: minimum_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE,
14: precision FND_CURRENCIES.precision%TYPE
15: );
16:
17: TYPE func_curr_det_tab IS TABLE OF func_curr_details

Line 14: precision FND_CURRENCIES.precision%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
13: minimum_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE,
14: precision FND_CURRENCIES.precision%TYPE
15: );
16:
17: TYPE func_curr_det_tab IS TABLE OF func_curr_details
18: INDEX BY BINARY_INTEGER;

Line 51: CURSOR get_curr_details (cp_curr IN fnd_currencies.currency_code%TYPE) is

47: WHERE ledger_id = cp_ledger_id;
48:
49: /* Bug 5243532. Added by Lakshmi Gopalsami */
50: /* Currency precision details */
51: CURSOR get_curr_details (cp_curr IN fnd_currencies.currency_code%TYPE) is
52: SELECT minimum_accountable_unit minimum_acct_unit,
53: PRECISION
54: FROM fnd_currencies
55: WHERE currency_code = cp_curr;

Line 54: FROM fnd_currencies

50: /* Currency precision details */
51: CURSOR get_curr_details (cp_curr IN fnd_currencies.currency_code%TYPE) is
52: SELECT minimum_accountable_unit minimum_acct_unit,
53: PRECISION
54: FROM fnd_currencies
55: WHERE currency_code = cp_curr;
56:
57: /* Read from cache */
58: FUNCTION read_cache