eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_STRM_ELEMENTS

Line 1129: FROM OKL_STRM_ELEMENTS STRE, OKL_STREAMS STR

1125:
1126:
1127: CURSOR C_OKL_CNSLD_AR_STRMB IS
1128: SELECT SUM(STRE.AMOUNT)
1129: FROM OKL_STRM_ELEMENTS STRE, OKL_STREAMS STR
1130: WHERE STR.KHR_ID = P_IPYV_REC.KHR_ID
1131: AND STR.KLE_ID = P_IPYV_REC.KLE_ID
1132: AND STR.ID = STRE.STM_ID
1133: AND STRE.DATE_BILLED IS NOT NULL;

Line 1606: FROM okl_strm_elements STRE, OKL_STREAMS STR

1602:
1603:
1604: CURSOR c_total_paid(l_stm_type_id NUMBER) IS
1605: SELECT SUM(STRE.AMOUNT)
1606: FROM okl_strm_elements STRE, OKL_STREAMS STR
1607: WHERE STR.ID = STRE.STM_ID
1608: AND STR.STY_ID = l_stm_type_id
1609: AND STRE.DATE_BILLED IS NOT NULL
1610: AND STR.KHR_ID = p_ipyv_rec.KHR_ID

Line 2801: FROM okl_strm_elements STRE, OKL_STREAMS STR

2797:
2798: --Get total amount paid by the customer
2799: CURSOR c_total_amount_paid (c_sty_id NUMBER,c_contract_id NUMBER,c_contract_line_id NUMBER)IS
2800: SELECT COUNT(*)
2801: FROM okl_strm_elements STRE, OKL_STREAMS STR
2802: WHERE STR.ID = STRE.STM_ID
2803: AND STR.STY_ID = c_sty_id
2804: AND STRE.DATE_BILLED IS NOT NULL
2805: AND STR.KHR_ID = c_contract_id

Line 2938: FROM okl_strm_elements STRE, OKL_STREAMS STR

2934: GROUP BY OINB.IPY_ID;
2935: -- calculate total amount paid to vendor
2936: CURSOR c_total_paid(p_stm_type_id NUMBER) IS
2937: SELECT SUM(STRE.AMOUNT)
2938: FROM okl_strm_elements STRE, OKL_STREAMS STR
2939: WHERE STR.ID = STRE.STM_ID
2940: AND STR.STY_ID = p_stm_type_id
2941: AND STRE.DATE_BILLED IS NOT NULL
2942: AND STR.KHR_ID = p_ipyv_rec.KHR_ID

Line 3269: OKL_STRM_ELEMENTS STEM

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
3273: AND STM.ID = STEM.STM_ID

Line 3278: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

3274: AND STEM.DATE_BILLED IS NOT NULL ;
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

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 3906: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

3902: l_ins_try_id NUMBER;
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

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 3915: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

3911: AND STM.ID = STEM.STM_ID
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

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

Line 5927: OKL_STRM_ELEMENTS STEM

5923: -- cursor changed to take the stream type id as the parameter, for user defined streams, bug 3924300
5924: CURSOR c_total_billed(l_khr_id NUMBER, l_kle_id NUMBER,l_stream_type_id NUMBER) IS
5925: SELECT SUM(amount)
5926: FROM OKL_STREAMS STM,
5927: OKL_STRM_ELEMENTS STEM
5928: where STM.STY_ID = l_stream_type_id
5929: AND STM.KLE_ID = l_kle_id
5930: AND STM.KHR_ID = l_khr_id
5931: AND STM.ID = STEM.STM_ID

Line 5937: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

5933:
5934: -- cursor changed to take the stream type id as the parameter, for user defined streams, bug 3924300
5935: CURSOR c_total_paid(l_khr_id NUMBER, l_kle_id NUMBER,l_stream_type_id NUMBER) IS
5936: SELECT SUM(amount)
5937: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
5938: WHERE STM.STY_ID = l_stream_type_id
5939: AND STM.KLE_ID = l_kle_id
5940: AND STM.KHR_ID = l_khr_id
5941: AND STM.ID = STEM.STM_ID

Line 5947: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

5943:
5944: -- cursor changed to take the stream type id as the parameter, for user defined streams, bug 3924300
5945: CURSOR c_total_bill_accrued(l_khr_id NUMBER, l_kle_id NUMBER, l_stream_type_id NUMBER) IS
5946: SELECT SUM(amount)
5947: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
5948: WHERE STM.STY_ID = l_stream_type_id
5949: AND STM.KLE_ID = l_kle_id
5950: AND STM.KHR_ID = l_khr_id
5951: AND STM.ID = STEM.STM_ID

Line 5959: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

5955: -- cursor changed to take the stream type id as the parameter, for user defined streams, bug 3924300
5956:
5957: CURSOR c_total_payment_accrued(l_khr_id NUMBER, l_kle_id NUMBER, l_stream_type_id NUMBER) IS
5958: SELECT SUM(amount)
5959: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
5960: WHERE STM.STY_ID = l_stream_type_id
5961: AND STM.KLE_ID = l_kle_id
5962: AND STM.KHR_ID = l_khr_id
5963: AND STM.ID = STEM.STM_ID

Line 6034: FROM okl_strm_elements STRE,

6030: -- smoduga added for 3845998
6031: -- Cursor to get the maximum billed date for insurance recievables
6032: Cursor rcvbl_max_billed_date (c_sty_id NUMBER, c_khr_id NUMBER, c_kle_id NUMBER) IS
6033: SELECT max (stre.date_billed)
6034: FROM okl_strm_elements STRE,
6035: OKL_STREAMS STR
6036: WHERE STR.ID = STRE.STM_ID
6037: AND STR.STY_ID = c_sty_id
6038: AND STRE.DATE_BILLED IS NOT NULL