APPS.OKL_CONTRACT_TOP_LINE_PVT dependencies on OKL_STRMTYP_SOURCE_V

Line 620: l_cap_yn OKL_STRMTYP_SOURCE_V.CAPITALIZE_YN%type := null;

616:
617: l_start_date okc_k_headers_b.start_date%type := null;
618: l_end_date okc_k_headers_b.end_date%type := null;
619:
620: l_cap_yn OKL_STRMTYP_SOURCE_V.CAPITALIZE_YN%type := null;
621: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%type := null;
622:
623: CURSOR get_capitalize_yn_csr(cap_yn VARCHAR2) IS
624: SELECT CAPITALIZE_YN

Line 625: FROM OKL_STRMTYP_SOURCE_V OKL_STRMTYP

621: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%type := null;
622:
623: CURSOR get_capitalize_yn_csr(cap_yn VARCHAR2) IS
624: SELECT CAPITALIZE_YN
625: FROM OKL_STRMTYP_SOURCE_V OKL_STRMTYP
626: WHERE OKL_STRMTYP.NAME = cap_yn
627: AND OKL_STRMTYP.STATUS = 'A';
628:
629: CURSOR get_lty_code_csr(lse_id NUMBER) IS

Line 956: l_cap_yn OKL_STRMTYP_SOURCE_V.CAPITALIZE_YN%type := null;

952:
953: l_start_date okc_k_headers_b.start_date%type := null;
954: l_end_date okc_k_headers_b.end_date%type := null;
955:
956: l_cap_yn OKL_STRMTYP_SOURCE_V.CAPITALIZE_YN%type := null;
957: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%type := null;
958:
959: CURSOR get_capitalize_yn_csr(cap_yn VARCHAR2) IS
960: SELECT CAPITALIZE_YN

Line 961: FROM OKL_STRMTYP_SOURCE_V OKL_STRMTYP

957: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%type := null;
958:
959: CURSOR get_capitalize_yn_csr(cap_yn VARCHAR2) IS
960: SELECT CAPITALIZE_YN
961: FROM OKL_STRMTYP_SOURCE_V OKL_STRMTYP
962: WHERE OKL_STRMTYP.NAME = cap_yn
963: AND OKL_STRMTYP.STATUS = 'A';
964:
965: CURSOR get_lty_code_csr(lse_id NUMBER) IS

Line 1785: okl_strmtyp_source_v stream

1781: p_line_id OKC_K_LINES_B.ID%TYPE) IS
1782: SELECT stream.capitalize_yn
1783: FROM okl_k_lines_full_v line,
1784: okc_k_items_v item,
1785: okl_strmtyp_source_v stream
1786: WHERE line.id = p_line_id
1787: AND line.dnz_chr_id = p_chr_id
1788: AND line.id = item.cle_id
1789: AND item.object1_id1 = stream.id1;