DBA Data[Home] [Help]

APPS.AR_UNPOSTED_ITEM_UTIL dependencies on FND_CURRENCIES

Line 27: FROM fnd_currencies

23:
24: CURSOR CurrencyCursor( cp_currency_code VARCHAR2 ) IS
25: SELECT precision,
26: minimum_accountable_unit
27: FROM fnd_currencies
28: WHERE currency_code = cp_currency_code;
29:
30:
31: PROCEDURE GetCurrencyDetails( p_currency_code IN VARCHAR2,

Line 77: CURSOR curr_info (cc FND_CURRENCIES.CURRENCY_CODE%TYPE) IS

73: exchange_rate IN NUMBER,
74: precision IN NUMBER,
75: min_acc_unit IN NUMBER) RETURN NUMBER IS
76:
77: CURSOR curr_info (cc FND_CURRENCIES.CURRENCY_CODE%TYPE) IS
78: SELECT PRECISION,
79: MINIMUM_ACCOUNTABLE_UNIT,
80: CURRENCY_CODE
81: FROM FND_CURRENCIES

Line 81: FROM FND_CURRENCIES

77: CURSOR curr_info (cc FND_CURRENCIES.CURRENCY_CODE%TYPE) IS
78: SELECT PRECISION,
79: MINIMUM_ACCOUNTABLE_UNIT,
80: CURRENCY_CODE
81: FROM FND_CURRENCIES
82: WHERE CURRENCY_CODE = cc;
83: curr curr_info%ROWTYPE;
84: loc_amount NUMBER;
85: invalid_params EXCEPTION;

Line 163: p_base_currency IN fnd_currencies.currency_code%TYPE,

159:
160:
161: PROCEDURE Set_Buckets(
162: p_header_acctd_amt IN NUMBER ,
163: p_base_currency IN fnd_currencies.currency_code%TYPE,
164: p_exchange_rate IN NUMBER ,
165: p_base_precision IN NUMBER ,
166: p_base_min_acc_unit IN NUMBER ,
167: p_tax_amt IN NUMBER ,