APPS.OKL_LA_STREAM_PVT dependencies on OKL_STREAM_INTERFACES

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

6482: , OKL_STRM_TYPE_B STY -- vdamerla Forward Ported Bug 6082209
6483: WHERE SEL.STM_ID = STM.ID
6484: AND STM.KHR_ID = cp_chr_id
6485: AND STM.KLE_ID = cp_cle_id
6486: AND (nvl(STM.purpose_code,'ORIG') = (select nvl(si.PURPOSE_CODE,'ORIG') from okl_stream_interfaces si
6487: where transaction_number = cp_trx_number))
6488: AND STM.SAY_CODE = 'CURR'
6489: -- vdamerla Forward Ported Bug6344223
6490: AND SEL.STREAM_ELEMENT_DATE <= nvl(cp_date_terminated, SEL.STREAM_ELEMENT_DATE)

Line 6552: from okl_stream_interfaces si

6548: AND stm.say_code = 'CURR'
6549: AND stm.kle_id = ln.id
6550: AND ln.STS_CODE = 'TERMINATED'
6551: AND (nvl(stm.purpose_code,'ORIG') = (select nvl(si.PURPOSE_CODE,'ORIG')
6552: from okl_stream_interfaces si
6553: where si.transaction_number = p_trx_number));
6554:
6555: --Cursor to get the line terminated date
6556: --Modified by vdamerla for bug 6344223

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

6581: , OKL_STRM_TYPE_B STY
6582: WHERE SEL.STM_ID = STM.ID
6583: AND STM.KHR_ID = cp_chr_id
6584: AND STM.KLE_ID IS NULL
6585: AND (nvl(STM.purpose_code,'ORIG') = (select nvl(si.PURPOSE_CODE,'ORIG') from okl_stream_interfaces si
6586: where transaction_number = cp_trx_number))
6587: AND STM.SAY_CODE = 'CURR'
6588: AND STM.SGN_CODE <> 'INTC'
6589: AND STM.STY_ID = STY.ID

Line 6641: from okl_stream_interfaces

6637:
6638: --Cursor to get the purpose code to identify whether it is a regular or reporting product call
6639: CURSOR c_get_purpose_code IS
6640: select nvl(purpose_code,'ORIGIN')
6641: from okl_stream_interfaces
6642: where transaction_number = p_trx_number;
6643:
6644: --To get the regular product id
6645: CURSOR c_get_regular_product_id IS

Line 6690: l_purpose_code okl_stream_interfaces.purpose_code%TYPE;

6686: AND rbk_khr.STATUS <> 'PROCESSED')
6687: AND TXL.QTE_ID = TRX.QTE_ID;
6688:
6689: l_accrual_previous_mnth_yn VARCHAR2(3);
6690: l_purpose_code okl_stream_interfaces.purpose_code%TYPE;
6691: l_product_id okl_products.id%TYPE;
6692: l_temp_term_date DATE;
6693: l_chk_accrual_stream VARCHAR2(1);
6694: l_curr_term_flag VARCHAR2(1);

Line 7123: okl_stream_interfaces sif,

7119: SELECT DISTINCT cle.id line_id,
7120: lev.rate
7121: FROM okl_sif_ret_levels lev,
7122: okl_sif_rets ret,
7123: okl_stream_interfaces sif,
7124: okl_sif_lines line,
7125: okc_k_lines_b cle,
7126: okl_k_lines kle,
7127: okc_line_styles_b lse,

Line 7143: FROM okl_stream_interfaces

7139: AND kle.fee_type = 'FINANCED'
7140: AND fee.fee_index_number = lev.index_number
7141: AND line.sil_type = 'SGN'
7142: AND sif.transaction_number IN (SELECT MAX(transaction_number)
7143: FROM okl_stream_interfaces
7144: WHERE khr_id = p_chr_id
7145: AND purpose_code IS NULL);
7146: -- get payment levels for line
7147: CURSOR get_level_csr(p_chr_id NUMBER,

Line 7253: FROM OKL_STREAM_INTERFACES SIF

7249: CURSOR get_stream_req_status_csr(p_khr_id NUMBER)
7250: IS
7251: SELECT * FROM (
7252: SELECT SIF.SIS_CODE REQUEST_STATUS
7253: FROM OKL_STREAM_INTERFACES SIF
7254: WHERE SIF.KHR_ID = p_khr_id
7255: AND SIF.PURPOSE_CODE = 'REPORT'
7256: ORDER BY SIF.TRANSACTION_NUMBER DESC)
7257: WHERE ROWNUM < 2;

Line 7264: FROM OKL_STREAM_INTERFACES SIF

7260: CURSOR get_rep_trans_num(p_khr_id NUMBER)
7261: IS
7262: SELECT * FROM (
7263: SELECT SIF.TRANSACTION_NUMBER TRANSACTION_NUMBER
7264: FROM OKL_STREAM_INTERFACES SIF
7265: WHERE SIF.KHR_ID = p_khr_id
7266: AND SIF.PURPOSE_CODE = 'REPORT'
7267: ORDER BY SIF.TRANSACTION_NUMBER DESC)
7268: WHERE ROWNUM < 2;