DBA Data[Home] [Help]

APPS.OKL_INS_QUOTE_PVT dependencies on OKL_STRM_TMPT_LINES_UV

Line 7755: from OKL_STRM_TMPT_LINES_UV stl,

7751: select stream_type_purpose from okl_strm_type_b
7752: where stream_type_purpose like 'INSURANCE%'
7753: AND stream_type_purpose NOT IN
7754: (select stl.primary_sty_purpose
7755: from OKL_STRM_TMPT_LINES_UV stl,
7756: okc_k_headers_b chr,
7757: okl_k_headers oklchr
7758: where stl.primary_sty_purpose like 'INSURANCE%'
7759: and stl.primary_yn = 'Y'

Line 7778: from OKL_STRM_TMPT_LINES_UV

7774: where id = p_contract_id;
7775:
7776: Cursor get_st_gen_template_set_name(p_pdt_id NUMBER) is
7777: Select st_gen_tmpt_set_name
7778: from OKL_STRM_TMPT_LINES_UV
7779: where pdt_id = p_pdt_id
7780: and rownum<2;
7781:
7782: FUNCTION get_quote_type (