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.

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_STRM_ELEMENTS

Line 1110: FROM OKL_STRM_ELEMENTS STRE, OKL_STREAMS STR

1106:
1107:
1108: CURSOR C_OKL_CNSLD_AR_STRMB IS
1109: SELECT SUM(STRE.AMOUNT)
1110: FROM OKL_STRM_ELEMENTS STRE, OKL_STREAMS STR
1111: WHERE STR.KHR_ID = P_IPYV_REC.KHR_ID
1112: AND STR.KLE_ID = P_IPYV_REC.KLE_ID
1113: AND STR.ID = STRE.STM_ID
1114: AND STRE.DATE_BILLED IS NOT NULL;

Line 1587: FROM okl_strm_elements STRE, OKL_STREAMS STR

1583:
1584:
1585: CURSOR c_total_paid(l_stm_type_id NUMBER) IS
1586: SELECT SUM(STRE.AMOUNT)
1587: FROM okl_strm_elements STRE, OKL_STREAMS STR
1588: WHERE STR.ID = STRE.STM_ID
1589: AND STR.STY_ID = l_stm_type_id
1590: AND STRE.DATE_BILLED IS NOT NULL
1591: AND STR.KHR_ID = p_ipyv_rec.KHR_ID

Line 2782: FROM okl_strm_elements STRE, OKL_STREAMS STR

2778:
2779: --Get total amount paid by the customer
2780: CURSOR c_total_amount_paid (c_sty_id NUMBER,c_contract_id NUMBER,c_contract_line_id NUMBER)IS
2781: SELECT COUNT(*)
2782: FROM okl_strm_elements STRE, OKL_STREAMS STR
2783: WHERE STR.ID = STRE.STM_ID
2784: AND STR.STY_ID = c_sty_id
2785: AND STRE.DATE_BILLED IS NOT NULL
2786: AND STR.KHR_ID = c_contract_id

Line 2919: FROM okl_strm_elements STRE, OKL_STREAMS STR

2915: GROUP BY OINB.IPY_ID;
2916: -- calculate total amount paid to vendor
2917: CURSOR c_total_paid(p_stm_type_id NUMBER) IS
2918: SELECT SUM(STRE.AMOUNT)
2919: FROM okl_strm_elements STRE, OKL_STREAMS STR
2920: WHERE STR.ID = STRE.STM_ID
2921: AND STR.STY_ID = p_stm_type_id
2922: AND STRE.DATE_BILLED IS NOT NULL
2923: AND STR.KHR_ID = p_ipyv_rec.KHR_ID

Line 3250: OKL_STRM_ELEMENTS STEM

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

Line 3259: --FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

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

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

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

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

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

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

Line 5934: OKL_STRM_ELEMENTS STEM

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

Line 5944: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

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

Line 5954: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

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

Line 5966: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM

5962: -- cursor changed to take the stream type id as the parameter, for user defined streams, bug 3924300
5963:
5964: CURSOR c_total_payment_accrued(l_khr_id NUMBER, l_kle_id NUMBER, l_stream_type_id NUMBER) IS
5965: SELECT SUM(amount)
5966: FROM OKL_STREAMS STM , OKL_STRM_ELEMENTS STEM
5967: WHERE STM.STY_ID = l_stream_type_id
5968: AND STM.KLE_ID = l_kle_id
5969: AND STM.KHR_ID = l_khr_id
5970: AND STM.ID = STEM.STM_ID

Line 6041: FROM okl_strm_elements STRE,

6037: -- smoduga added for 3845998
6038: -- Cursor to get the maximum billed date for insurance recievables
6039: Cursor rcvbl_max_billed_date (c_sty_id NUMBER, c_khr_id NUMBER, c_kle_id NUMBER) IS
6040: SELECT max (stre.date_billed)
6041: FROM okl_strm_elements STRE,
6042: OKL_STREAMS STR
6043: WHERE STR.ID = STRE.STM_ID
6044: AND STR.STY_ID = c_sty_id
6045: AND STRE.DATE_BILLED IS NOT NULL