[Home] [Help]
3464:
3465:
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
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:
4561: -- Start of comments
4562: --
4563: -- Procedure Name : create_offlease_asset_trx
4564: -- Description : This procedure gets all Fixed Asset Lines (off-lease assets)
4565: -- for a particular contract using okx_asset_lines_v view and then calls the line level procedure
4566: -- to create amortization transactions.
4567: -- Business Rules :
4568: -- Parameters : p_contract_id - Contract id
4569: -- p_early_termination_yn - early termination / end of term flag
4586: /* -- SECHAWLA 19-NOV-2004 4022466
4587: -- This cursor is used to get all the line items for a given contract
4588: CURSOR l_linesv_csr IS
4589: SELECT parent_line_id
4590: FROM okx_asset_lines_v
4591: WHERE dnz_chr_id = p_contract_id;
4592: */
4593:
4594: -- SECHAWLA 19-NOV-2004 4022466 :added