APPS.OKL_AM_AMORTIZE_PVT dependencies on OKL_K_HEADERS

Line 50: FROM okc_k_headers_b a, okl_k_headers b

46:
47: -- Get the financial product of the contract
48: CURSOR l_get_fin_product(cp_khr_id IN NUMBER) IS
49: SELECT a.start_date, a.contract_number, b.pdt_id
50: FROM okc_k_headers_b a, okl_k_headers b
51: WHERE a.id = b.id
52: AND a.id = cp_khr_id;
53:
54: SUBTYPE pdtv_rec_type IS OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

Line 3470: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

3466:
3467:
3468: l_corporate_book okx_asset_lines_v.corporate_book%TYPE;
3469:
3470: l_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
3471:
3472: --SECHAWLA 03-JAN-03 Bug # 2683876 : new declaration
3473: l_func_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
3474:

Line 3521: FROM okx_asset_lines_v lines, OKL_K_HEADERS_FULL_V hdr

3517: -- This cursor will return all the Fixed Asset Lines for a particular contract.
3518: CURSOR l_linesv_csr IS
3519: SELECT dnz_chr_id, depreciation_category, corporate_book, salvage_value, deprn_method_code, life_in_months,
3520: asset_number, item_description, asset_id,original_cost, current_units, in_service_date, deal_type
3521: FROM okx_asset_lines_v lines, OKL_K_HEADERS_FULL_V hdr
3522: WHERE lines.dnz_chr_id = hdr.id
3523: AND lines.parent_line_id = p_kle_id;
3524: */
3525:

Line 3730: FROM okl_k_headers a, okc_k_lines_b b

3726: -- SECHAWLA 06-MAY-04 3578894 : Added this cursor
3727: -- get the deal type for the asset
3728: CURSOR l_oklhdr_csr(cp_kle_id IN NUMBER) IS
3729: SELECT a.id, a.deal_type, a.legal_entity_id
3730: FROM okl_k_headers a, okc_k_lines_b b
3731: WHERE a.id = b.dnz_chr_id
3732: AND b.id = cp_kle_id;
3733:
3734: -- SECHAWLA 06-MAY-04 3578894 : Added this cursor to validate the kle id