APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_STREAMS_REP_V

Line 3268: FROM OKL_STREAMS_REP_V STM, -- MGAAP 7263041

3264: l_ipyv_rec ipyv_rec_type;
3265: CURSOR c_total_billed(l_khr_id NUMBER, l_kle_id NUMBER,l_stream_type_id NUMBER) IS
3266: SELECT SUM(amount)
3267: --FROM OKL_STREAMS STM,
3268: FROM OKL_STREAMS_REP_V STM, -- MGAAP 7263041
3269: OKL_STRM_ELEMENTS STEM
3270: where STM.STY_ID = l_stream_type_id
3271: AND STM.KLE_ID = l_kle_id
3272: AND STM.KHR_ID = l_khr_id

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

3275: -- cursor changed to take the stream type id as the parameter, for user defined streams, bug 3924300
3276: CURSOR c_total_bill_accrued(l_khr_id NUMBER, l_kle_id NUMBER, l_stream_type_id NUMBER) IS
3277: SELECT SUM(amount)
3278: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
3279: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM --MGAAP 7263041
3280: WHERE STM.STY_ID = l_stream_type_id
3281: AND STM.KLE_ID = l_kle_id
3282: AND STM.KHR_ID = l_khr_id
3283: AND STM.ID = STEM.STM_ID

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

3903: l_ipyv_rec ipyv_rec_type;
3904: CURSOR c_total_paid(l_khr_id NUMBER, l_kle_id NUMBER,l_stream_type_id NUMBER) IS
3905: SELECT SUM(amount)
3906: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
3907: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM -- MGAAP
3908: WHERE STM.STY_ID = l_stream_type_id
3909: AND STM.KLE_ID = l_kle_id
3910: AND STM.KHR_ID = l_khr_id
3911: AND STM.ID = STEM.STM_ID

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

3912: AND STEM.DATE_BILLED IS NOT NULL;
3913: CURSOR c_total_payment_accrued(l_khr_id NUMBER, l_kle_id NUMBER, l_stream_type_id NUMBER) IS
3914: SELECT SUM(amount)
3915: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
3916: FROM OKL_STREAMS_REP_V STM , OKL_STRM_ELEMENTS STEM -- MGAAP
3917: WHERE STM.STY_ID = l_stream_type_id
3918: AND STM.KLE_ID = l_kle_id
3919: AND STM.KHR_ID = l_khr_id
3920: AND STM.ID = STEM.STM_ID