APPS.OKL_RECEIPTS_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 551: ra_customer_trx_all b

547:
548: CURSOR c_fetch_inv_currency(p_customer_trx_line_id IN NUMBER) IS
549: select b.INVOICE_CURRENCY_CODE
550: from ra_customer_trx_lines_all a,
551: ra_customer_trx_all b
552: where a.customer_trx_line_id=p_customer_trx_line_id
553: and a.customer_trx_id = b.customer_trx_id;
554:
555: CURSOR c_fetch_receipt_currency(p_cash_rcpt_id IN NUMBER) IS

Line 1681: l_ar_inv_number ra_customer_trx_all.trx_number%TYPE;

1677: l_customer_number hz_cust_accounts.account_number%TYPE:=p_rcpt_rec.customer_number;
1678: l_org_id NUMBER:= p_rcpt_rec.org_id;
1679: l_contract_number okc_k_headers_all_b.contract_number%TYPE;
1680: l_cons_inv_number okl_cnsld_ar_hdrs_all_b.consolidated_invoice_number%TYPE;
1681: l_ar_inv_number ra_customer_trx_all.trx_number%TYPE;
1682: l_ar_invoice_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
1683:
1684:
1685: l_appl_tbl APPL_TBL_TYPE DEFAULT p_appl_tbl;

Line 1742: FROM ra_customer_trx_all

1738: CURSOR c_ar_inv_num( cp_ar_inv_id IN NUMBER
1739: ,cp_org_id IN NUMBER
1740: ) IS
1741: SELECT trx_number
1742: FROM ra_customer_trx_all
1743: WHERE customer_trx_id = cp_ar_inv_id
1744: AND org_id = cp_org_id;
1745:
1746: CURSOR c_ar_inv_line_id(cp_ar_inv_id IN NUMBER, cp_org_id IN NUMBER) IS

Line 1761: FROM ra_customer_trx_all a

1757: WHERE cash_receipt_id = cp_cash_receipt_id;
1758:
1759: CURSOR c_fetch_inv_currency (p_customer_trx_id IN NUMBER) IS
1760: SELECT a.invoice_currency_code
1761: FROM ra_customer_trx_all a
1762: WHERE a.customer_trx_id = p_customer_trx_id;
1763:
1764: BEGIN
1765: log_debug('okl_receipts_pvt.handle_receipts start +');