APPS.OKL_LCKBX_CSH_APP_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 64: FROM ra_customer_trx_all

60: --asawanka modified for lla start
61: --this function should return true if ar_inv_ref is a valid non okl ar invoice
62: SELECT COUNT (*)
63: INTO inv_count
64: FROM ra_customer_trx_all
65: WHERE trx_number = ar_inv_ref
66: AND org_id = p_org_id
67: AND interface_header_context <> 'OKL_CONTRACTS';
68:

Line 190: l_invoice_currency_code RA_CUSTOMER_TRX_ALL.INVOICE_CURRENCY_CODE%TYPE;

186: AND org_id = cp_org_id
187: and CURRENCY_CODE = nvl(cp_currency_code,CURRENCY_CODE)
188: AND status = 'OP';
189:
190: l_invoice_currency_code RA_CUSTOMER_TRX_ALL.INVOICE_CURRENCY_CODE%TYPE;
191: l_precision NUMBER;
192: l_amount_to NUMBER;
193: l_amount_from NUMBER;
194: BEGIN