APPS.OKL_CASH_APPL_RULES dependencies on OKL_CNSLD_AR_STRMS_B

Line 290: FROM OKL_STRM_TYP_ALLOCS sta, OKL_CNSLD_AR_STRMS_B st

286: CURSOR c_stream_alloc ( cp_str_all_type IN VARCHAR2
287: ,cp_cat_id IN NUMBER
288: ,cp_khr_id IN NUMBER) IS
289: SELECT distinct sta.sty_id, sta.sequence_number
290: FROM OKL_STRM_TYP_ALLOCS sta, OKL_CNSLD_AR_STRMS_B st
291: WHERE sta.stream_allc_type = cp_str_all_type
292: AND sta.cat_id = cp_cat_id
293: AND st.khr_id = cp_khr_id
294: AND sta.sty_id = st.sty_id

Line 322: OKL_CNSLD_AR_STRMS_B ST,

318: CN.CONTRACT_NUMBER CONTRACT_NUMBER ,
319: CN.START_DATE START_DATE
320: from
321: OKC_K_HEADERS_ALL_B CN,
322: OKL_CNSLD_AR_STRMS_B ST,
323: OKL_CNSLD_AR_HDRS_B HD,
324: HZ_CUST_ACCOUNTS CA,
325: OKL_CNSLD_AR_LINES_B LN,
326: AR_PAYMENT_SCHEDULES_ALL PS

Line 351: OKL_CNSLD_AR_STRMS_B ST,

347: CURSOR c_get_contract_id (cp_contract_num IN VARCHAR2) IS
348: select ST.KHR_ID CONTRACT_ID
349: from
350: OKC_K_HEADERS_ALL_B CN,
351: OKL_CNSLD_AR_STRMS_B ST,
352: AR_PAYMENT_SCHEDULES_ALL PS
353: WHERE PS.CLASS IN ('INV', 'CM')
354: AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID
355: AND CN.ID = ST.KHR_ID