APPS.OKL_LA_STREAM_PVT dependencies on OKL_STREAM_INTERFACES

Line 6882: AND (nvl(STM.purpose_code,'ORIG') = (select nvl(si.PURPOSE_CODE,'ORIG') from okl_stream_interfaces si

6878: , OKL_STRM_TYPE_B STY
6879: WHERE SEL.STM_ID = STM.ID
6880: AND STM.KHR_ID = cp_chr_id
6881: AND STM.KLE_ID = cp_cle_id
6882: AND (nvl(STM.purpose_code,'ORIG') = (select nvl(si.PURPOSE_CODE,'ORIG') from okl_stream_interfaces si
6883: where transaction_number = cp_trx_number))
6884: AND STM.SAY_CODE = 'CURR'
6885: AND SEL.STREAM_ELEMENT_DATE <= cp_date_terminated
6886: AND STM.STY_ID = STY.ID

Line 7923: AND (nvl(STM.purpose_code,'ORIG') = (select nvl(si.PURPOSE_CODE,'ORIG') from okl_stream_interfaces si

7919: , OKL_STRM_TYPE_B STY -- vdamerla Forward Ported Bug 6082209
7920: WHERE SEL.STM_ID = STM.ID
7921: AND STM.KHR_ID = cp_chr_id
7922: AND STM.KLE_ID = cp_cle_id
7923: AND (nvl(STM.purpose_code,'ORIG') = (select nvl(si.PURPOSE_CODE,'ORIG') from okl_stream_interfaces si
7924: where transaction_number = cp_trx_number))
7925: AND STM.SAY_CODE = 'CURR'
7926: -- vdamerla Forward Ported Bug6344223
7927: AND SEL.STREAM_ELEMENT_DATE <= nvl(cp_date_terminated, SEL.STREAM_ELEMENT_DATE)

Line 7990: from okl_stream_interfaces si

7986: AND stm.say_code = 'CURR'
7987: AND stm.kle_id = ln.id
7988: AND ln.STS_CODE = 'TERMINATED'
7989: AND (nvl(stm.purpose_code,'ORIG') = (select nvl(si.PURPOSE_CODE,'ORIG')
7990: from okl_stream_interfaces si
7991: where si.transaction_number = p_trx_number));
7992:
7993: --Cursor to get the line terminated date
7994: --Modified by vdamerla for bug 6344223

Line 8023: AND (nvl(STM.purpose_code,'ORIG') = (select nvl(si.PURPOSE_CODE,'ORIG') from okl_stream_interfaces si

8019: , OKL_STRM_TYPE_B STY
8020: WHERE SEL.STM_ID = STM.ID
8021: AND STM.KHR_ID = cp_chr_id
8022: AND STM.KLE_ID IS NULL
8023: AND (nvl(STM.purpose_code,'ORIG') = (select nvl(si.PURPOSE_CODE,'ORIG') from okl_stream_interfaces si
8024: where transaction_number = cp_trx_number))
8025: AND STM.SAY_CODE = 'CURR'
8026: AND STM.SGN_CODE <> 'INTC'
8027: AND STM.STY_ID = STY.ID

Line 8079: from okl_stream_interfaces

8075:
8076: --Cursor to get the purpose code to identify whether it is a regular or reporting product call
8077: CURSOR c_get_purpose_code IS
8078: select nvl(purpose_code,'ORIGIN')
8079: from okl_stream_interfaces
8080: where transaction_number = p_trx_number;
8081:
8082: --To get the regular product id
8083: CURSOR c_get_regular_product_id IS

Line 8157: l_purpose_code okl_stream_interfaces.purpose_code%TYPE;

8153: AND TXL.QTE_ID = TRX.QTE_ID;
8154:
8155:
8156: l_accrual_previous_mnth_yn VARCHAR2(3);
8157: l_purpose_code okl_stream_interfaces.purpose_code%TYPE;
8158: l_product_id okl_products.id%TYPE;
8159: l_temp_term_date DATE;
8160: l_chk_accrual_stream VARCHAR2(1);
8161: l_curr_term_flag VARCHAR2(1);

Line 8617: okl_stream_interfaces sif,

8613: SELECT DISTINCT cle.id line_id,
8614: lev.rate
8615: FROM okl_sif_ret_levels lev,
8616: okl_sif_rets ret,
8617: okl_stream_interfaces sif,
8618: okl_sif_lines line,
8619: okc_k_lines_b cle,
8620: okl_k_lines kle,
8621: okc_line_styles_b lse,

Line 8637: FROM okl_stream_interfaces

8633: AND kle.fee_type = 'FINANCED'
8634: AND fee.fee_index_number = lev.index_number
8635: AND line.sil_type = 'SGN'
8636: AND sif.transaction_number IN (SELECT MAX(transaction_number)
8637: FROM okl_stream_interfaces
8638: WHERE khr_id = p_chr_id
8639: AND purpose_code IS NULL);
8640: -- get payment levels for line
8641: CURSOR get_level_csr(p_chr_id NUMBER,

Line 8747: FROM OKL_STREAM_INTERFACES SIF

8743: CURSOR get_stream_req_status_csr(p_khr_id NUMBER)
8744: IS
8745: SELECT * FROM (
8746: SELECT SIF.SIS_CODE REQUEST_STATUS
8747: FROM OKL_STREAM_INTERFACES SIF
8748: WHERE SIF.KHR_ID = p_khr_id
8749: AND SIF.PURPOSE_CODE = 'REPORT'
8750: ORDER BY SIF.TRANSACTION_NUMBER DESC)
8751: WHERE ROWNUM < 2;

Line 8758: FROM OKL_STREAM_INTERFACES SIF

8754: CURSOR get_rep_trans_num(p_khr_id NUMBER)
8755: IS
8756: SELECT * FROM (
8757: SELECT SIF.TRANSACTION_NUMBER TRANSACTION_NUMBER
8758: FROM OKL_STREAM_INTERFACES SIF
8759: WHERE SIF.KHR_ID = p_khr_id
8760: AND SIF.PURPOSE_CODE = 'REPORT'
8761: ORDER BY SIF.TRANSACTION_NUMBER DESC)
8762: WHERE ROWNUM < 2;