DBA Data[Home] [Help]

APPS.OKL_RELEASE_PVT dependencies on OKL_STREAMS

Line 3940: FROM okl_streams stm

3936: p_cle_id IN NUMBER,
3937: p_sty_id IN NUMBER)
3938: IS
3939: SELECT stm.id
3940: FROM okl_streams stm
3941: WHERE stm.khr_id = p_chr_id
3942: AND stm.kle_id = p_cle_id
3943: AND stm.sty_id = p_sty_id
3944: AND stm.active_yn = 'Y'

Line 3984: OKL_STREAMS_UTIL.get_dependent_stream_type

3980: END IF;
3981:
3982: -- Fetch Stream information from Original Contract
3983: l_principal_bal_sty_id := null;
3984: OKL_STREAMS_UTIL.get_dependent_stream_type
3985: (p_khr_id => p_orig_chr_id,
3986: p_primary_sty_id => p_pymt_sty_id,
3987: p_dependent_sty_purpose => 'PRINCIPAL_BALANCE',
3988: x_return_status => x_return_status,

Line 4242: FROM okl_streams stm

4238: p_cle_id IN NUMBER,
4239: p_sty_id IN NUMBER)
4240: IS
4241: SELECT stm.id
4242: FROM okl_streams stm
4243: WHERE stm.khr_id = p_chr_id
4244: AND stm.kle_id = p_cle_id
4245: AND stm.sty_id = p_sty_id
4246: AND stm.active_yn = 'Y'

Line 4964: OKL_STREAMS_UTIL.get_dependent_stream_type

4960: close fee_item_csr;
4961:
4962: -- Fetch Stream information from Original Contract
4963: l_idc_sty_id := null;
4964: OKL_STREAMS_UTIL.get_dependent_stream_type
4965: (p_khr_id => p_orig_chr_id,
4966: p_primary_sty_id => fee_item_rec.object1_id1,
4967: p_dependent_sty_purpose => 'AMORTIZED_FEE_EXPENSE',
4968: x_return_status => x_return_status,