APPS.OKL_AUTO_CASH_APPL_RULES_PVT dependencies on OKL_RCPT_ARINV_BALANCES_UV

Line 163: From OKL_RCPT_ARINV_BALANCES_UV

159: amount_due_remaining amount_due_remaining,
160: line_identifier Line_Identifier,
161: sty_id,
162: CONTRACT_NUMBER
163: From OKL_RCPT_ARINV_BALANCES_UV
164: Where Invoice_Number = cp_arinv_num
165: And Org_id = cp_org_id
166: --asawanka changed for bug #5391874
167: AND customer_account_number = nvl(p_customer_num,customer_account_number)

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 227: FROM OKL_RCPT_ARINV_BALANCES_UV lpt

223:
224: -- Cursor to fetch contract id , contract number group under an AR Invoice Number
225: CURSOR c_get_contract_num (l_inv_ref IN VARCHAR2,l_org_id IN NUMBER) IS
226: SELECT lpt.khr_id contract_id, lpt.CONTRACT_NUMBER contract_number
227: FROM OKL_RCPT_ARINV_BALANCES_UV lpt
228: WHERE lpt.INVOICE_NUMBER = l_inv_ref
229: AND lpt.amount_due_remaining > 0
230: And lpt.org_id= l_org_id
231: ORDER BY lpt.start_date;