APPS.OKL_DEAL_ASSET_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 710: FROM okl_k_headers_full_v

706:
707: -- gboomina Modified this to get deal type and sts code also
708: CURSOR c_khr_info(p_khr_id NUMBER) IS
709: SELECT id, deal_type, sts_code
710: FROM okl_k_headers_full_v
711: WHERE id = p_khr_id;
712:
713: l_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE;
714: l_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;

Line 713: l_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE;

709: SELECT id, deal_type, sts_code
710: FROM okl_k_headers_full_v
711: WHERE id = p_khr_id;
712:
713: l_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE;
714: l_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
715: l_sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE;
716: l_is_contract_active BOOLEAN;
717:

Line 714: l_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;

710: FROM okl_k_headers_full_v
711: WHERE id = p_khr_id;
712:
713: l_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE;
714: l_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
715: l_sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE;
716: l_is_contract_active BOOLEAN;
717:
718: CURSOR c_item_line(p_dnz_chr_id NUMBER, p_clev_fin_id NUMBER) IS

Line 715: l_sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE;

711: WHERE id = p_khr_id;
712:
713: l_khr_id OKL_K_HEADERS_FULL_V.ID%TYPE;
714: l_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
715: l_sts_code OKL_K_HEADERS_FULL_V.STS_CODE%TYPE;
716: l_is_contract_active BOOLEAN;
717:
718: CURSOR c_item_line(p_dnz_chr_id NUMBER, p_clev_fin_id NUMBER) IS
719: SELECT cleb_mdl.id clev_model_id,