DBA Data[Home] [Help]

APPS.OKL_BILLING_RECON_RPT_PVT dependencies on FND_CURRENCIES_VL

Line 30: currency_code fnd_currencies_vl.currency_code%TYPE,

26: -- Record Type for reconciliation report format
27: -- ----------------------------------------------------------
28: TYPE recon_fmt_rec_type IS RECORD (
29: CONTRACT_NUMBER okl_k_headers_full_v.contract_number%TYPE,
30: currency_code fnd_currencies_vl.currency_code%TYPE,
31: okl_count NUMBER,
32: okl_amount NUMBER,
33: ar_count NUMBER,
34: ar_amount NUMBER,

Line 327: FROM fnd_currencies_vl

323: l_amount_format VARCHAR2(25) := '999,999,999,990.999';
324:
325: CURSOR curr_precision_csr( p_curr_code VARCHAR2 ) IS
326: SELECT precision
327: FROM fnd_currencies_vl
328: WHERE CURRENCY_CODE = p_curr_code;
329:
330: l_precision fnd_currencies_vl.precision%TYPE;
331:

Line 330: l_precision fnd_currencies_vl.precision%TYPE;

326: SELECT precision
327: FROM fnd_currencies_vl
328: WHERE CURRENCY_CODE = p_curr_code;
329:
330: l_precision fnd_currencies_vl.precision%TYPE;
331:
332: CURSOR int_err_csr( p_in_contract_number VARCHAR2
333: ,p_in_from_bill_date DATE
334: ,p_in_to_bill_date DATE) IS