APPS.OKL_SECURITIZATION_PVT dependencies on OKL_STRM_ELEMENTS

Line 974: p_sel_id IN okl_strm_elements.ID%TYPE

970: -- Version : 1.0
971: -- End of comments
972: ----------------------------------------------------------------------------------
973: FUNCTION is_sel_securitized(
974: p_sel_id IN okl_strm_elements.ID%TYPE
975: ,p_effective_date IN DATE
976: ) RETURN VARCHAR
977: IS
978: l_dummy VARCHAR2(1);

Line 982: CURSOR c_sel(p_sel_id okl_strm_elements.ID%TYPE, p_effective_date DATE) IS

978: l_dummy VARCHAR2(1);
979: x_value VARCHAR2(1) := Okl_Api.G_FALSE;
980: l_row_found BOOLEAN := FALSE;
981:
982: CURSOR c_sel(p_sel_id okl_strm_elements.ID%TYPE, p_effective_date DATE) IS
983: SELECT '1'
984: FROM okl_streams strm
985: ,okl_strm_elements ele
986: ,okl_pool_contents pl

Line 985: ,okl_strm_elements ele

981:
982: CURSOR c_sel(p_sel_id okl_strm_elements.ID%TYPE, p_effective_date DATE) IS
983: SELECT '1'
984: FROM okl_streams strm
985: ,okl_strm_elements ele
986: ,okl_pool_contents pl
987: ,okl_pools ph
988: ,okc_k_headers_b khr
989: WHERE strm.id = ele.stm_id

Line 1054: ,p_sel_id IN okl_strm_elements.ID%TYPE

1050: ,p_init_msg_list IN VARCHAR2
1051: ,x_return_status OUT NOCOPY VARCHAR2
1052: ,x_msg_count OUT NOCOPY NUMBER
1053: ,x_msg_data OUT NOCOPY VARCHAR2
1054: ,p_sel_id IN okl_strm_elements.ID%TYPE
1055: ,p_effective_date IN DATE
1056: ,x_value OUT NOCOPY VARCHAR2
1057: )
1058: IS