APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_STREAMS

Line 113: FROM OKL_STREAMS STM,

109: CURSOR disb_sel_amt_csr ( p_ia_id NUMBER,
110: p_rbk_khr_id NUMBER,
111: p_rbk_kle_id NUMBER ) IS
112: SELECT NVL(SUM(SEL.AMOUNT),0)
113: FROM OKL_STREAMS STM,
114: OKL_STRM_ELEMENTS SEL,
115: OKL_STRM_TYPE_V STY
116: WHERE STM.KHR_ID = p_rbk_khr_id
117: AND NVL(STM.KLE_ID,-99) = NVL ( p_rbk_kle_id,-99 )

Line 828: okl_streams stm,

824: --ssiruvol Bug 5000886 end
825: oklh.deal_type deal_type
826: FROM
827: okl_strm_elements ste,
828: okl_streams stm,
829: okl_strm_type_v sty,
830: okc_k_headers_b khr,
831: okl_k_headers oklh
832: WHERE trunc(ste.stream_element_date) <= trunc(NVL(p_date_to, SYSDATE))

Line 885: okl_streams stm,

881: okl_strm_elements ste,
882: -- Bug 4550607
883: okl_strm_elements ste1,
884: -- End Bug 4550607
885: okl_streams stm,
886: okl_strm_type_v sty,
887: okc_k_headers_b khr,
888: okl_k_headers khl,
889: okc_statuses_b khs ,

Line 1235: OKL_STREAMS STM

1231: -----------------------------------------------------------------
1232: CURSOR get_parent_sty ( p_ref_sel_id NUMBER ) IS
1233: SELECT STM.STY_ID
1234: FROM OKL_STRM_ELEMENTS SEL,
1235: OKL_STREAMS STM
1236: WHERE SEL.ID = p_ref_sel_id
1237: AND SEL.STM_ID = STM.ID;
1238:
1239: CURSOR get_parent_stake ( p_top_line_id NUMBER

Line 1484: Okl_Streams_Util.get_primary_stream_type(

1480:
1481: l_sty_id := NULL;
1482: IF inv_disb_rec.Stream_purpose = 'INVESTOR_RENT_DISB_BASIS' THEN
1483:
1484: Okl_Streams_Util.get_primary_stream_type(
1485: p_khr_id => inv_lease_k_rec.Investor_Agreement_ID,
1486: p_primary_sty_purpose => 'INVESTOR_RENT_PAYABLE',
1487: x_return_status => l_return_status,
1488: x_primary_sty_id => l_sty_id );

Line 1494: Okl_Streams_Util.get_primary_stream_type(

1490: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -*- No attached INVESTOR_RENT_PAYABLE stream type found.');
1491: END IF;
1492: ELSIF inv_disb_rec.Stream_purpose = 'INVESTOR_PRINCIPAL_DISB_BASIS' THEN
1493:
1494: Okl_Streams_Util.get_primary_stream_type(
1495: p_khr_id => inv_lease_k_rec.Investor_Agreement_ID,
1496: p_primary_sty_purpose => 'INVESTOR_PRINCIPAL_PAYABLE',
1497: x_return_status => l_return_status,
1498: x_primary_sty_id => l_sty_id );

Line 1504: Okl_Streams_Util.get_primary_stream_type(

1500: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -*- No attached INVESTOR_PRINCIPAL_PAYABLE stream type found.');
1501: END IF;
1502: ELSIF inv_disb_rec.Stream_purpose = 'INVESTOR_INTEREST_DISB_BASIS' THEN
1503:
1504: Okl_Streams_Util.get_primary_stream_type(
1505: p_khr_id => inv_lease_k_rec.Investor_Agreement_ID,
1506: p_primary_sty_purpose => 'INVESTOR_INTEREST_PAYABLE',
1507: x_return_status => l_return_status,
1508: x_primary_sty_id => l_sty_id );

Line 1514: Okl_Streams_Util.get_primary_stream_type(

1510: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -*- No attached INVESTOR_INTEREST_PAYABLE stream type found.');
1511: END IF;
1512: ELSIF inv_disb_rec.Stream_purpose = 'INVESTOR_PPD_DISB_BASIS' THEN
1513:
1514: Okl_Streams_Util.get_primary_stream_type(
1515: p_khr_id => inv_lease_k_rec.Investor_Agreement_ID,
1516: p_primary_sty_purpose => 'INVESTOR_PAYDOWN_PAYABLE',
1517: x_return_status => l_return_status,
1518: x_primary_sty_id => l_sty_id );