APPS.OKL_AUTO_CASH_APPL_RULES_PVT dependencies on OKL_RCPT_CONSINV_BALANCES_UV

Line 2968: FROM okl_rcpt_consinv_balances_uv lpt

2964: ,lpt.ar_invoice_line_id
2965: ,lpt.ar_invoice_line_number
2966: ,lpt.trx_date invoice_date
2967: ,lpt.contract_number
2968: FROM okl_rcpt_consinv_balances_uv lpt
2969: WHERE lpt.consolidated_invoice_id = cp_cons_bill_id
2970: --asawanka changed for bug #5391874
2971: AND lpt.customer_account_number = nvl(cp_customer_num,lpt.customer_account_number)
2972: AND lpt.org_id=cp_org_id

Line 2986: FROM okl_rcpt_consinv_balances_uv lpt

2982: CURSOR c_inv_date ( cp_cons_bill_id IN NUMBER
2983: ,cp_customer_num IN VARCHAR2) IS
2984: SELECT DISTINCT(lpt.contract_number)
2985: ,lpt.invoice_date Start_date, lpt.contract_id,lpt.currency_code
2986: FROM okl_rcpt_consinv_balances_uv lpt
2987: WHERE lpt.consolidated_invoice_id = cp_cons_bill_id --Always passing cp_cons_bill_id as not null so no need to have nvl
2988: AND lpt.customer_account_number = NVL (cp_customer_num, lpt.customer_account_number);
2989:
2990:

Line 3040: FROM okl_rcpt_consinv_balances_uv lpt, okc_k_headers_all_b khr

3036: ----------
3037: -- get a contract number if not known
3038: CURSOR c_get_contract_num (cp_cons_bill_id IN NUMBER) IS
3039: SELECT lpt.contract_id, lpt.contract_number
3040: FROM okl_rcpt_consinv_balances_uv lpt, okc_k_headers_all_b khr
3041: WHERE lpt.consolidated_invoice_id = cp_cons_bill_id
3042: AND lpt.status = 'OP'
3043: AND lpt.amount_due_remaining > 0
3044: AND khr.id = lpt.contract_id