DBA Data[Home] [Help]

APPS.OKL_CASH_APPL_RULES dependencies on OKL_STRM_TYP_ALLOCS

Line 165: l_sequence_number OKL_STRM_TYP_ALLOCS.SEQUENCE_NUMBER%TYPE DEFAULT NULL;

161: l_dflt_months_to_bill_ahead OKL_CASH_ALLCTN_RLS.MONTHS_TO_BILL_AHEAD%TYPE DEFAULT NULL;
162: l_dflt_under_payment OKL_CASH_ALLCTN_RLS.UNDER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
163: l_dflt_over_payment OKL_CASH_ALLCTN_RLS.OVER_PAYMENT_ALLOCATION_CODE%TYPE DEFAULT NULL;
164: l_dflt_receipt_msmtch OKL_CASH_ALLCTN_RLS.RECEIPT_MSMTCH_ALLOCATION_CODE%TYPE DEFAULT NULL;
165: l_sequence_number OKL_STRM_TYP_ALLOCS.SEQUENCE_NUMBER%TYPE DEFAULT NULL;
166:
167: l_dup_rcpt_flag NUMBER DEFAULT NULL;
168: l_create_receipt_flag VARCHAR2(2) DEFAULT p_create_receipt_flag;
169: l_cash_applied_flag VARCHAR2(1) DEFAULT NULL;

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