APPS.OKL_AM_RV_WRITEDOWN_PVT dependencies on OKC_K_HEADERS_B

Line 63: l_contract_curr_code okc_k_headers_b.currency_code%TYPE;

59: l_count NUMBER;
60:
61: --SECHAWLA Bug # 2726739 : new declarations
62: l_func_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
63: l_contract_curr_code okc_k_headers_b.currency_code%TYPE;
64: lx_contract_currency okl_k_headers_full_v.currency_code%TYPE;
65: lx_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
66: lx_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
67: lx_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

Line 74: FROM okl_k_lines_full_v l, okc_k_headers_b h

70:
71: -- This cursor selects line item fields and contract status for a given line ID
72: CURSOR l_linesfullv_csr(p_id NUMBER) IS
73: SELECT l.name, l.item_description, l.residual_value, l.oec, l.chr_id, h.contract_number
74: FROM okl_k_lines_full_v l, okc_k_headers_b h
75: WHERE l.chr_id = h.id
76: AND l.id = p_id;
77: -- we can use chr_id in the above cursor as we will be pulling data only for the TOP LINE (Financial Asset) which
78: -- will always have the chr_id.