DBA Data[Home] [Help]

APPS.OKL_INS_QUOTE_PVT dependencies on OKL_STREAMS_V

Line 5837: FROM Okl_Streams_V

5833: REQUEST_ID,
5834: PROGRAM_APPLICATION_ID,
5835: PROGRAM_UPDATE_DATE,
5836: LAST_UPDATE_LOGIN
5837: FROM Okl_Streams_V
5838: WHERE okl_streams_v.khr_id = p_khr_id AND
5839: okl_streams_v.kle_id = p_kle_id
5840: AND okl_streams_v.sty_id = p_sty_id;
5841: l_okl_stmv_pk okl_stmv_pk_csr%ROWTYPE;

Line 5838: WHERE okl_streams_v.khr_id = p_khr_id AND

5834: PROGRAM_APPLICATION_ID,
5835: PROGRAM_UPDATE_DATE,
5836: LAST_UPDATE_LOGIN
5837: FROM Okl_Streams_V
5838: WHERE okl_streams_v.khr_id = p_khr_id AND
5839: okl_streams_v.kle_id = p_kle_id
5840: AND okl_streams_v.sty_id = p_sty_id;
5841: l_okl_stmv_pk okl_stmv_pk_csr%ROWTYPE;
5842: l_stmv_rec Okl_Stm_Pvt.stmv_rec_type;

Line 5839: okl_streams_v.kle_id = p_kle_id

5835: PROGRAM_UPDATE_DATE,
5836: LAST_UPDATE_LOGIN
5837: FROM Okl_Streams_V
5838: WHERE okl_streams_v.khr_id = p_khr_id AND
5839: okl_streams_v.kle_id = p_kle_id
5840: AND okl_streams_v.sty_id = p_sty_id;
5841: l_okl_stmv_pk okl_stmv_pk_csr%ROWTYPE;
5842: l_stmv_rec Okl_Stm_Pvt.stmv_rec_type;
5843: BEGIN

Line 5840: AND okl_streams_v.sty_id = p_sty_id;

5836: LAST_UPDATE_LOGIN
5837: FROM Okl_Streams_V
5838: WHERE okl_streams_v.khr_id = p_khr_id AND
5839: okl_streams_v.kle_id = p_kle_id
5840: AND okl_streams_v.sty_id = p_sty_id;
5841: l_okl_stmv_pk okl_stmv_pk_csr%ROWTYPE;
5842: l_stmv_rec Okl_Stm_Pvt.stmv_rec_type;
5843: BEGIN
5844: x_no_data_found := TRUE;