APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_STREAMS_REP_V

Line 3249: FROM OKL_STREAMS_REP_V STM, -- MGAAP 7263041

3245: l_ipyv_rec ipyv_rec_type;
3246: CURSOR c_total_billed(l_khr_id NUMBER, l_kle_id NUMBER,l_stream_type_id NUMBER) IS
3247: SELECT SUM(amount)
3248: --FROM OKL_STREAMS STM,
3249: FROM OKL_STREAMS_REP_V STM, -- MGAAP 7263041
3250: OKL_STRM_ELEMENTS STEM
3251: where STM.STY_ID = l_stream_type_id
3252: AND STM.KLE_ID = l_kle_id
3253: AND STM.KHR_ID = l_khr_id

Line 3260: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM --MGAAP 7263041

3256: -- cursor changed to take the stream type id as the parameter, for user defined streams, bug 3924300
3257: CURSOR c_total_bill_accrued(l_khr_id NUMBER, l_kle_id NUMBER, l_stream_type_id NUMBER) IS
3258: SELECT SUM(amount)
3259: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
3260: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM --MGAAP 7263041
3261: WHERE STM.STY_ID = l_stream_type_id
3262: AND STM.KLE_ID = l_kle_id
3263: AND STM.KHR_ID = l_khr_id
3264: AND STM.ID = STEM.STM_ID

Line 3883: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM -- MGAAP

3879: l_ipyv_rec ipyv_rec_type;
3880: CURSOR c_total_paid(l_khr_id NUMBER, l_kle_id NUMBER,l_stream_type_id NUMBER) IS
3881: SELECT SUM(amount)
3882: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
3883: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM -- MGAAP
3884: WHERE STM.STY_ID = l_stream_type_id
3885: AND STM.KLE_ID = l_kle_id
3886: AND STM.KHR_ID = l_khr_id
3887: AND STM.ID = STEM.STM_ID

Line 3892: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM -- MGAAP

3888: AND STEM.DATE_BILLED IS NOT NULL;
3889: CURSOR c_total_payment_accrued(l_khr_id NUMBER, l_kle_id NUMBER, l_stream_type_id NUMBER) IS
3890: SELECT SUM(amount)
3891: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
3892: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM -- MGAAP
3893: WHERE STM.STY_ID = l_stream_type_id
3894: AND STM.KLE_ID = l_kle_id
3895: AND STM.KHR_ID = l_khr_id
3896: AND STM.ID = STEM.STM_ID