APPS.OKL_POOL_PVT dependencies on OKL_STRM_ELEMENTS

Line 1663: ,okl_strm_elements ele

1659: -- SUM(ele.AMOUNT) STREAM_AMOUNT --fixed cklee 06/05/2003
1660: --for streams
1661: FROM
1662: okl_streams strm
1663: ,okl_strm_elements ele
1664: ,okl_pool_contents cnt
1665: WHERE strm.id = ele.stm_id
1666: AND cnt.ID = p_poc_id
1667: -- mvasudev, 08/11/2003 , Restoring stm_id changes

Line 1797: ,okl_strm_elements ele

1793: CURSOR c_strm_amount ( p_poc_id NUMBER)
1794: IS
1795: SELECT NVL(SUM(NVL(ele.AMOUNT,0)),0) STREAM_AMOUNT
1796: FROM okl_streams strm
1797: ,okl_strm_elements ele
1798: ,okl_pool_contents cnt
1799: WHERE strm.id = ele.stm_id
1800: AND cnt.ID = p_poc_id
1801: AND strm.ID = cnt.STM_ID

Line 3165: okl_strm_elements sel

3161: IS
3162: SELECT '1'
3163: FROM okl_pool_contents pol_cnts,
3164: okl_strm_type_b styb,
3165: okl_strm_elements sel
3166: WHERE pol_cnts.pol_id = pol_id
3167: AND pol_cnts.stm_id = p_stm_id
3168: AND styb.stream_type_subclass = p_stream_type_subclass
3169: AND pol_cnts.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE,G_POC_STS_PENDING)

Line 3946: ,okl_strm_elements ele

3942: CURSOR c_strm_amount ( p_poc_id NUMBER)
3943: IS
3944: SELECT NVL(SUM(NVL(ele.AMOUNT,0)),0) STREAM_AMOUNT
3945: FROM okl_streams strm
3946: ,okl_strm_elements ele
3947: ,okl_pool_contents cnt
3948: WHERE strm.id = ele.stm_id
3949: AND cnt.ID = p_poc_id
3950: AND strm.ID = cnt.STM_ID

Line 4239: FROM okl_strm_elements selb

4235:
4236: OR NOT EXISTS
4237: (
4238: SELECT '1'
4239: FROM okl_strm_elements selb
4240: WHERE selb.stm_id = stmb.id
4241: )
4242: );
4243: */

Line 4288: FROM okl_strm_elements selb

4284: -- cklee 04/10/2003 never reconcile historical data
4285: AND poc.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
4286: -- cklee 04/10/2003 never reconcile historical data
4287: AND TRUNC(poc.streams_from_date) <> ( SELECT TRUNC(MIN(selb.stream_element_date))
4288: FROM okl_strm_elements selb
4289: WHERE selb.stm_id = stmb.id
4290: AND selb.date_billed IS NULL
4291: AND selb.amount <> 0 -- vsgandhi : Bug 13997160
4292: -- mvasudev, 02/06/2004

Line 4454: FROM okl_strm_elements selb

4450: -- cklee 04/10/2003 never reconcile historical data
4451: AND poc.status_code IN (G_POC_STS_PENDING)
4452: -- cklee 04/10/2003 never reconcile historical data
4453: AND TRUNC(poc.streams_from_date) <> ( SELECT TRUNC(MIN(selb.stream_element_date))
4454: FROM okl_strm_elements selb
4455: WHERE selb.stm_id = stmb.id
4456: AND selb.date_billed IS NULL
4457: AND selb.amount <> 0 -- vsgandhi : Bug 13997160
4458: -- mvasudev, 02/06/2004

Line 4467: FROM okl_strm_elements selb

4463:
4464: CURSOR l_okl_valid_dates_csr(p_stm_id IN NUMBER)
4465: IS
4466: SELECT MIN(selb.stream_element_date)
4467: FROM okl_strm_elements selb
4468: ,okl_streams stmb
4469: WHERE selb.stm_id = stmb.id
4470: AND selb.date_billed IS NULL
4471: AND selb.amount <> 0 -- vsgandhi : Bug 13997160

Line 5313: ,okl_strm_elements selb

5309: CURSOR l_okl_poc_stm_csr
5310: IS
5311: SELECT NVL(SUM(NVL(selb.amount,0)),0) amount
5312: FROM okl_streams stmb
5313: ,okl_strm_elements selb
5314: ,okl_pool_contents pocb
5315: ,okl_strm_type_v styv
5316: ,okc_k_headers_b chrb
5317: WHERE pocb.stm_id = stmb.id

Line 5347: ,okl_strm_elements selb

5343: CURSOR l_okl_poc_csr
5344: IS
5345: SELECT NVL(SUM(NVL(selb.amount,0)),0) amount
5346: FROM okl_streams stmb
5347: ,okl_strm_elements selb
5348: ,okl_pool_contents pocb
5349: WHERE pocb.stm_id = stmb.id
5350: AND stmb.id = selb.stm_id
5351: AND pocb.id = p_poc_id