APPS.OKL_COMBI_CASH_APP_RLS_PVT dependencies on OKL_RCPT_CUST_CONT_BALANCES_UV

Line 88: FROM okl_rcpt_cust_cont_balances_uv

84:
85: -- get unique contract number
86: CURSOR c_get_contract(cp_cust_num IN VARCHAR2,cp_org_id IN NUMBER) IS
87: SELECT distinct(contract_number)
88: FROM okl_rcpt_cust_cont_balances_uv
89: WHERE customer_number = cp_cust_num
90: AND org_id= cp_org_id
91: ORDER BY invoice_due_date;
92:

Line 417: FROM OKL_RCPT_CUST_CONT_BALANCES_UV

413: INVOICE_LINE_ID,
414: LINE_NUMBER,
415: AMOUNT_DUE_REMAINING,
416: CURRENCY_CODE
417: FROM OKL_RCPT_CUST_CONT_BALANCES_UV
418: WHERE CONTRACT_NUMBER = NVL (cp_contract_num, CONTRACT_NUMBER)
419: AND STY_ID = NVL(cp_stream_type_id, STY_ID)
420: AND CUSTOMER_ACCOUNT_NUMBER = cp_customer_num
421: AND ORG_ID = cp_org_id