APPS.OKL_CASH_APPL_RULES dependencies on OKL_K_HEADERS_FULL_V

Line 478: FROM okl_k_headers_full_v

474:
475:
476: --start code by pgomes on 03/05/2003
477: CURSOR l_khr_curr_csr(cp_contract_id IN NUMBER) IS SELECT currency_code
478: FROM okl_k_headers_full_v
479: WHERE id = cp_contract_id;
480:
481: CURSOR l_inv_curr_csr(cp_cons_bill_id IN NUMBER) IS SELECT currency_code
482: FROM okl_cnsld_ar_hdrs_b

Line 485: l_currency_code okl_k_headers_full_v.currency_code%type;

481: CURSOR l_inv_curr_csr(cp_cons_bill_id IN NUMBER) IS SELECT currency_code
482: FROM okl_cnsld_ar_hdrs_b
483: WHERE id = cp_cons_bill_id;
484:
485: l_currency_code okl_k_headers_full_v.currency_code%type;
486: --end code by pgomes on 03/05/2003
487: BEGIN
488:
489: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2206: l_currency_code okl_k_headers_full_v.currency_code%type;

2202: ,p_rcpt_rec IN rcpt_rec_type
2203: ,x_cash_receipt_id OUT NOCOPY NUMBER
2204: ) IS
2205:
2206: l_currency_code okl_k_headers_full_v.currency_code%type;
2207: l_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT p_rcpt_rec.customer_id;
2208: l_customer_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE DEFAULT p_rcpt_rec.customer_number;
2209: l_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
2210: l_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT p_rcpt_rec.exchange_rate_type;