APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKC_K_HEADERS_V

Line 929: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';

925: G_EXCEPTION_STOP_VALIDATION EXCEPTION;
926: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
927: G_MODEL_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ITEM';
928: G_ADDON_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ADD_ITEM';
929: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
930: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
931: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
932: l_api_name CONSTANT VARCHAR2(30) := 'FUNCTION_OEC_CALC';
933: ln_contract_oec OKL_K_LINES_V.OEC%TYPE := 0;

Line 930: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';

926: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
927: G_MODEL_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ITEM';
928: G_ADDON_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ADD_ITEM';
929: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
930: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
931: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
932: l_api_name CONSTANT VARCHAR2(30) := 'FUNCTION_OEC_CALC';
933: ln_contract_oec OKL_K_LINES_V.OEC%TYPE := 0;
934: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

Line 947: CURSOR c_contract_oec_calc(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

943: okc_line_styles_b lse
944: WHERE cle.id = p_cle_id
945: AND cle.lse_id = lse.id;
946: -- Cursor to sum up oec for contract
947: CURSOR c_contract_oec_calc(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
948: SELECT SUM(kle.oec) oec
949: FROM OKL_K_LINES_V kle,
950: OKC_K_LINES_V cle,
951: OKC_K_HEADERS_V CHR

Line 951: OKC_K_HEADERS_V CHR

947: CURSOR c_contract_oec_calc(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
948: SELECT SUM(kle.oec) oec
949: FROM OKL_K_LINES_V kle,
950: OKC_K_LINES_V cle,
951: OKC_K_HEADERS_V CHR
952: WHERE CHR.id = p_dnz_chr_id
953: AND CHR.id = cle.dnz_chr_id
954: AND cle.sts_code NOT IN ( 'ABANDONED', 'TERMINATED', 'EXPIRED', 'CANCELLED', 'HOLD')
955: AND cle.id = kle.id;

Line 957: CURSOR c_contract_oec_calc_incl_term(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

953: AND CHR.id = cle.dnz_chr_id
954: AND cle.sts_code NOT IN ( 'ABANDONED', 'TERMINATED', 'EXPIRED', 'CANCELLED', 'HOLD')
955: AND cle.id = kle.id;
956:
957: CURSOR c_contract_oec_calc_incl_term(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
958: SELECT SUM(kle.oec) oec
959: FROM OKL_K_LINES_V kle,
960: OKC_K_LINES_V cle,
961: OKC_K_HEADERS_V CHR

Line 961: OKC_K_HEADERS_V CHR

957: CURSOR c_contract_oec_calc_incl_term(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
958: SELECT SUM(kle.oec) oec
959: FROM OKL_K_LINES_V kle,
960: OKC_K_LINES_V cle,
961: OKC_K_HEADERS_V CHR
962: WHERE CHR.id = p_dnz_chr_id
963: AND CHR.id = cle.dnz_chr_id
964: AND cle.sts_code NOT IN ( 'ABANDONED', 'EXPIRED', 'CANCELLED', 'HOLD')
965: AND cle.id = kle.id;

Line 4312: FROM okc_k_headers_v h

4308:
4309: -- Get header number to use in error messages
4310: CURSOR l_chr_csr (cp_chr_id NUMBER) IS
4311: SELECT h.contract_number
4312: FROM okc_k_headers_v h
4313: WHERE h.id = cp_chr_id;
4314:
4315: l_result_amount NUMBER := 0;
4316: l_no_taxable_amount EXCEPTION;

Line 5938: okc_k_headers_v okh

5934: FROM okl_streams_v asv,okl_strm_type_v bs,
5935: okl_strm_elements_v cs,
5936: okl_streams str,
5937: okl_strm_type_v sty,
5938: okc_k_headers_v okh
5939: WHERE cs.stm_id = asv.id AND bs.id = asv.sty_id
5940: AND str.sty_id = sty.id
5941: AND UPPER(sty.name) = 'PRINCIPAL BALANCE'
5942: AND str.say_code = 'CURR'