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 1624: l_ar_inv_number ra_customer_trx_all.trx_number%TYPE;

1620: l_customer_number hz_cust_accounts.account_number%TYPE:=p_rcpt_rec.customer_number;
1621: l_org_id NUMBER:= p_rcpt_rec.org_id;
1622: l_contract_number okc_k_headers_all_b.contract_number%TYPE;
1623: l_cons_inv_number okl_cnsld_ar_hdrs_all_b.consolidated_invoice_number%TYPE;
1624: l_ar_inv_number ra_customer_trx_all.trx_number%TYPE;
1625: l_ar_invoice_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
1626:
1627:
1628: l_appl_tbl APPL_TBL_TYPE DEFAULT p_appl_tbl;

Line 1685: FROM ra_customer_trx_all

1681: CURSOR c_ar_inv_num( cp_ar_inv_id IN NUMBER
1682: ,cp_org_id IN NUMBER
1683: ) IS
1684: SELECT trx_number
1685: FROM ra_customer_trx_all
1686: WHERE customer_trx_id = cp_ar_inv_id
1687: AND org_id = cp_org_id;
1688:
1689: CURSOR c_ar_inv_line_id(cp_ar_inv_id IN NUMBER, cp_org_id IN NUMBER) IS

Line 1704: FROM ra_customer_trx_all a

1700: WHERE cash_receipt_id = cp_cash_receipt_id;
1701:
1702: CURSOR c_fetch_inv_currency (p_customer_trx_id IN NUMBER) IS
1703: SELECT a.invoice_currency_code
1704: FROM ra_customer_trx_all a
1705: WHERE a.customer_trx_id = p_customer_trx_id;
1706:
1707: BEGIN
1708: log_debug('okl_receipts_pvt.handle_receipts start +');