APPS.OKL_AUTO_CASH_APPL_RULES_PVT dependencies on OKL_RCPT_CONSINV_BALANCES_UV

Line 2978: FROM okl_rcpt_consinv_balances_uv lpt

2974: ,lpt.ar_invoice_line_id
2975: ,lpt.ar_invoice_line_number
2976: ,lpt.trx_date invoice_date
2977: ,lpt.contract_number
2978: FROM okl_rcpt_consinv_balances_uv lpt
2979: WHERE lpt.consolidated_invoice_id = cp_cons_bill_id
2980: --asawanka changed for bug #5391874
2981: AND lpt.customer_account_number = nvl(cp_customer_num,lpt.customer_account_number)
2982: AND lpt.org_id=cp_org_id

Line 2996: FROM okl_rcpt_consinv_balances_uv lpt

2992: CURSOR c_inv_date ( cp_cons_bill_id IN NUMBER
2993: ,cp_customer_num IN VARCHAR2) IS
2994: SELECT DISTINCT(lpt.contract_number)
2995: ,lpt.invoice_date Start_date, lpt.contract_id,lpt.currency_code
2996: FROM okl_rcpt_consinv_balances_uv lpt
2997: WHERE lpt.consolidated_invoice_id = cp_cons_bill_id --Always passing cp_cons_bill_id as not null so no need to have nvl
2998: AND lpt.customer_account_number = NVL (cp_customer_num, lpt.customer_account_number);
2999:
3000:

Line 3050: FROM okl_rcpt_consinv_balances_uv lpt, okc_k_headers_all_b khr

3046: ----------
3047: -- get a contract number if not known
3048: CURSOR c_get_contract_num (cp_cons_bill_id IN NUMBER) IS
3049: SELECT lpt.contract_id, lpt.contract_number
3050: FROM okl_rcpt_consinv_balances_uv lpt, okc_k_headers_all_b khr
3051: WHERE lpt.consolidated_invoice_id = cp_cons_bill_id
3052: AND lpt.status = 'OP'
3053: AND lpt.amount_due_remaining > 0
3054: AND khr.id = lpt.contract_id