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 843: okl_streams stm,

839: --ssiruvol Bug 5000886 end
840: oklh.deal_type deal_type
841: FROM
842: okl_strm_elements ste,
843: okl_streams stm,
844: okl_strm_type_v sty,
845: okc_k_headers_b khr,
846: okl_k_headers oklh
847: WHERE trunc(ste.stream_element_date) <= trunc(NVL(p_date_to, SYSDATE))

Line 900: okl_streams stm,

896: okl_strm_elements ste,
897: -- Bug 4550607
898: okl_strm_elements ste1,
899: -- End Bug 4550607
900: okl_streams stm,
901: okl_strm_type_v sty,
902: okc_k_headers_b khr,
903: okl_k_headers khl,
904: okc_statuses_b khs ,

Line 1305: OKL_STREAMS STM

1301: -----------------------------------------------------------------
1302: CURSOR get_parent_sty ( p_ref_sel_id NUMBER ) IS
1303: SELECT STM.STY_ID
1304: FROM OKL_STRM_ELEMENTS SEL,
1305: OKL_STREAMS STM
1306: WHERE SEL.ID = p_ref_sel_id
1307: AND SEL.STM_ID = STM.ID;
1308:
1309: CURSOR get_parent_stake ( p_top_line_id NUMBER

Line 1554: Okl_Streams_Util.get_primary_stream_type(

1550:
1551: l_sty_id := NULL;
1552: IF inv_disb_rec.Stream_purpose = 'INVESTOR_RENT_DISB_BASIS' THEN
1553:
1554: Okl_Streams_Util.get_primary_stream_type(
1555: p_khr_id => inv_lease_k_rec.Investor_Agreement_ID,
1556: p_primary_sty_purpose => 'INVESTOR_RENT_PAYABLE',
1557: x_return_status => l_return_status,
1558: x_primary_sty_id => l_sty_id );

Line 1564: Okl_Streams_Util.get_primary_stream_type(

1560: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -*- No attached INVESTOR_RENT_PAYABLE stream type found.');
1561: END IF;
1562: ELSIF inv_disb_rec.Stream_purpose = 'INVESTOR_PRINCIPAL_DISB_BASIS' THEN
1563:
1564: Okl_Streams_Util.get_primary_stream_type(
1565: p_khr_id => inv_lease_k_rec.Investor_Agreement_ID,
1566: p_primary_sty_purpose => 'INVESTOR_PRINCIPAL_PAYABLE',
1567: x_return_status => l_return_status,
1568: x_primary_sty_id => l_sty_id );

Line 1574: Okl_Streams_Util.get_primary_stream_type(

1570: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -*- No attached INVESTOR_PRINCIPAL_PAYABLE stream type found.');
1571: END IF;
1572: ELSIF inv_disb_rec.Stream_purpose = 'INVESTOR_INTEREST_DISB_BASIS' THEN
1573:
1574: Okl_Streams_Util.get_primary_stream_type(
1575: p_khr_id => inv_lease_k_rec.Investor_Agreement_ID,
1576: p_primary_sty_purpose => 'INVESTOR_INTEREST_PAYABLE',
1577: x_return_status => l_return_status,
1578: x_primary_sty_id => l_sty_id );

Line 1584: Okl_Streams_Util.get_primary_stream_type(

1580: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' -*- No attached INVESTOR_INTEREST_PAYABLE stream type found.');
1581: END IF;
1582: ELSIF inv_disb_rec.Stream_purpose = 'INVESTOR_PPD_DISB_BASIS' THEN
1583:
1584: Okl_Streams_Util.get_primary_stream_type(
1585: p_khr_id => inv_lease_k_rec.Investor_Agreement_ID,
1586: p_primary_sty_purpose => 'INVESTOR_PAYDOWN_PAYABLE',
1587: x_return_status => l_return_status,
1588: x_primary_sty_id => l_sty_id );