APPS.OKL_DEAL_ASSET_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 668: FROM okl_k_headers_full_v

664:
665: -- gboomina Modified this to get deal type and sts code also
666: CURSOR c_khr_info(p_khr_id NUMBER) IS
667: SELECT id, deal_type, sts_code
668: FROM okl_k_headers_full_v
669: WHERE id = p_khr_id;
670:
671: l_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE;
672: l_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;

Line 671: l_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE;

667: SELECT id, deal_type, sts_code
668: FROM okl_k_headers_full_v
669: WHERE id = p_khr_id;
670:
671: l_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE;
672: l_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
673: l_sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE;
674: l_is_contract_active BOOLEAN;
675:

Line 672: l_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;

668: FROM okl_k_headers_full_v
669: WHERE id = p_khr_id;
670:
671: l_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE;
672: l_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
673: l_sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE;
674: l_is_contract_active BOOLEAN;
675:
676: CURSOR c_item_line(p_dnz_chr_id NUMBER, p_clev_fin_id NUMBER) IS

Line 673: l_sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE;

669: WHERE id = p_khr_id;
670:
671: l_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE;
672: l_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
673: l_sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE;
674: l_is_contract_active BOOLEAN;
675:
676: CURSOR c_item_line(p_dnz_chr_id NUMBER, p_clev_fin_id NUMBER) IS
677: SELECT cleb_mdl.id clev_model_id,