DBA Data[Home] [Help]

APPS.OKL_COMBI_CASH_APP_RLS_PVT dependencies on OKL_RCPT_ARINV_BALANCES_UV

Line 99: FROM okl_rcpt_arinv_balances_uv

95:
96: -- get unique ar invoice numbers
97: CURSOR c_get_ar_invs(cp_cust_num IN VARCHAR2,cp_org_id IN NUMBER) IS
98: SELECT distinct(invoice_number), invoice_due_date due_date
99: FROM okl_rcpt_arinv_balances_uv
100: WHERE customer_number = cp_cust_num
101: AND org_id= cp_org_id
102: ORDER BY invoice_due_date;
103:

Line 397: From OKL_RCPT_ARINV_BALANCES_UV

393: INVOICE_LINE_ID invoice_line_id,
394: Line_Identifier Line_Number,
395: amount_due_remaining amount_due_remaining,
396: invoice_currency_code CURRENCY_CODE
397: From OKL_RCPT_ARINV_BALANCES_UV
398: Where Invoice_Number = cp_ar_bill_num
399: And Org_id = cp_org_id
400: AND amount_due_remaining > 0
401: AND status = 'OP'