APPS.OKL_AUTO_CASH_APPL_RULES_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 181: From Okc_k_headers_all_b A, OKL_RCPT_ARINV_BALANCES_UV B

177: -- Cursor to fetch contract Id and contract start date with the AR invoice Number
178:
179: Cursor c_inv_date (cp_arinv_num IN VARCHAR2 , cp_org_id Number) IS
180: SELECT A.Id contract_id , A.start_date Start_Date
181: From Okc_k_headers_all_b A, OKL_RCPT_ARINV_BALANCES_UV B
182: Where B.Invoice_Number = cp_arinv_num
183: and a.contract_number = b.contract_number
184: And b.org_id= cp_org_id;
185:

Line 1631: FROM OKC_K_HEADERS_ALL_B

1627:
1628: -- get a contract id if not known
1629: CURSOR c_get_contract_id (cp_contract_num IN VARCHAR2) IS
1630: SELECT ID CONTRACT_ID, currency_code
1631: FROM OKC_K_HEADERS_ALL_B
1632: WHERE contract_number = cp_contract_num;
1633:
1634: l_unapply_amount NUMBER:=0;
1635: l_onacc_amount NUMBER:=0;

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