APPS.OKL_LCKBX_CSH_APP_PVT dependencies on RA_CUSTOMER_TRX

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

Line 270: FROM ra_customer_trx_lines

266: FUNCTION get_line_level_app (p_arinv_id IN NUMBER, p_org_id IN NUMBER)
267: RETURN VARCHAR2 AS
268: CURSOR c_is_llevel_balance (p_inv_id NUMBER, p_org_id NUMBER) IS
269: SELECT SUM (amount_due_remaining) due
270: FROM ra_customer_trx_lines
271: WHERE customer_trx_id = p_inv_id
272: AND org_id = p_org_id
273: AND line_type = 'LINE';
274:

Line 284: FROM ra_cust_trx_types ctt, ra_customer_trx ct

280: ctt.TYPE,
281: ct.initial_customer_trx_id,
282: ct.previous_customer_trx_id
283: ) activity
284: FROM ra_cust_trx_types ctt, ra_customer_trx ct
285: WHERE ct.customer_trx_id = p_inv_id
286: AND ct.org_id = p_org_id
287: AND ct.cust_trx_type_id = ctt.cust_trx_type_id;
288: