APPS.OKL_SERVICE_INTEGRATION_PVT dependencies on OKC_LINE_STYLES_V

Line 620: CURSOR line_style_csr (p_style okc_line_styles_v.lty_code%TYPE) IS

616: l_api_name VARCHAR2(35) := 'create_service_line';
617: l_proc_name VARCHAR2(35) := 'CREATE_SERVICE_LINE';
618: l_api_version CONSTANT NUMBER := 1;
619:
620: CURSOR line_style_csr (p_style okc_line_styles_v.lty_code%TYPE) IS
621: SELECT id
622: FROM okc_line_styles_v
623: WHERE lty_code = p_style;
624:

Line 622: FROM okc_line_styles_v

618: l_api_version CONSTANT NUMBER := 1;
619:
620: CURSOR line_style_csr (p_style okc_line_styles_v.lty_code%TYPE) IS
621: SELECT id
622: FROM okc_line_styles_v
623: WHERE lty_code = p_style;
624:
625: CURSOR currency_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
626: SELECT currency_code

Line 687: okc_line_styles_v s,

683: CURSOR srv_amt_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
684: p_srv_line_id OKC_K_LINES_V.ID%TYPE) IS
685: SELECT nvl(sum(l.price_negotiated),0) tot_amount
686: FROM okc_k_lines_v l,
687: okc_line_styles_v s,
688: okc_k_items_v item,
689: okx_install_items_v prod
690: WHERE l.lse_id = s.id
691: AND l.id = item.cle_id

Line 698: okc_line_styles_v style

694: SELECT 'Y'
695: FROM okc_k_items_v item,
696: okx_system_items_v mtl,
697: okc_k_lines_v line,
698: okc_line_styles_v style
699: WHERE item.object1_id1 = mtl.id1
700: AND item.object1_id2 = TO_CHAR(mtl.id2) -- Bug# 2887948
701: AND item.cle_id = line.id
702: AND line.lse_id = style.id

Line 3582: okc_line_styles_v style

3578: CURSOR oks_cov_csr(p_oks_serv_id OKC_K_LINES_V.ID%TYPE) IS
3579: SELECT line.id,
3580: line.price_negotiated
3581: FROM okc_k_lines_b line,
3582: okc_line_styles_v style
3583: WHERE line.lse_id = style.id
3584: AND cle_id = p_oks_serv_id
3585: AND lty_code = 'COVER_PROD'
3586: AND NOT EXISTS (SELECT 'Y'