[Home] [Help]
2739: SELECT name
2740: FROM OKC_K_LINES_V
2741: WHERE id = p_fin_line_id;
2742: --get asset add ons
2743: CURSOR c_get_asset_addons(p_ast_id okl_assets_b.ID%TYPE) IS
2744: SELECT oab.ID,
2745: oab.ASSET_NUMBER,
2746: oab.INSTALL_SITE_ID,
2747: oab.RATE_CARD_ID,
2972: AND oacb.PRIMARY_COMPONENT = 'YES'
2973: AND oab.PARENT_OBJECT_ID = p_qte_id;
2974: -- End : Added by rravikir for Bug#6707125
2975:
2976: CURSOR c_get_asset_subsidy(p_ast_id okl_assets_b.ID%TYPE) IS
2977: SELECT ADJUSTMENT_SOURCE_ID,
2978: VALUE,
2979: SUPPLIER_ID,
2980: default_subsidy_amount
3145: l_down_payment_receiver VARCHAR2(30);
3146: l_dp_exists BOOLEAN := FALSE;
3147:
3148: --cursor to fetch asset down payment adjustment details
3149: CURSOR get_asset_dp_details(p_ast_id IN okl_Assets_b.id%TYPE) IS
3150: SELECT
3151: id
3152: ,parent_object_code
3153: ,parent_object_id
3294: l_chr_id okl_k_headers.id%TYPE;
3295: l_ti_exists BOOLEAN := false;
3296:
3297: --cursor to fetch asset trade in adjustment details
3298: CURSOR get_asset_ti_details(p_ast_id IN okl_Assets_b.id%TYPE) IS
3299: SELECT
3300: id
3301: ,parent_object_code
3302: ,parent_object_id
3489: AND oacb.PRIMARY_COMPONENT = 'YES'
3490: AND oab.PARENT_OBJECT_ID = p_qte_id;
3491:
3492: --Get asset rent payment details
3493: CURSOR c_get_asset_payment_dtls(p_ast_id okl_assets_b.ID%TYPE) IS
3494: SELECT ocf.STY_ID payment_type_id,
3495: ocf.DUE_ARREARS_YN Arrears_YN,
3496: cfl.FQY_CODE Frequency_Code,
3497: cfl.START_DATE,
3503: OKL_CASH_FLOWS ocf,
3504: OKL_CASH_FLOW_LEVELS cfl
3505: WHERE cfl.caf_id = ocf.ID
3506: AND ocf.CFO_ID = cfo.ID
3507: AND cfo.SOURCE_TABLE = 'OKL_ASSETS_B'
3508: AND cfo.OTY_CODE = 'QUOTED_ASSET'
3509: AND cfo.SOURCE_ID = p_ast_id;
3510:
3511: --Get asset billed down payment details
3508: AND cfo.OTY_CODE = 'QUOTED_ASSET'
3509: AND cfo.SOURCE_ID = p_ast_id;
3510:
3511: --Get asset billed down payment details
3512: CURSOR c_get_asset_dppayment_dtls(p_ast_id okl_assets_b.ID%TYPE) IS
3513: SELECT ocf.STY_ID payment_type_id,
3514: ocf.DUE_ARREARS_YN Arrears_YN,
3515: cfl.FQY_CODE Frequency_Code,
3516: cfl.START_DATE,
3522: OKL_CASH_FLOWS ocf,
3523: OKL_CASH_FLOW_LEVELS cfl
3524: WHERE cfl.caf_id = ocf.ID
3525: AND ocf.CFO_ID = cfo.ID
3526: AND cfo.SOURCE_TABLE = 'OKL_ASSETS_B'
3527: AND cfo.OTY_CODE = 'QUOTED_ASSET_DOWN_PAYMENT'
3528: AND cfo.SOURCE_ID = p_ast_id;
3529:
3530: --Get asset estimated property tax payment details
3527: AND cfo.OTY_CODE = 'QUOTED_ASSET_DOWN_PAYMENT'
3528: AND cfo.SOURCE_ID = p_ast_id;
3529:
3530: --Get asset estimated property tax payment details
3531: CURSOR c_get_asset_eptpayment_dtls(p_ast_id okl_assets_b.ID%TYPE) IS
3532: SELECT ocf.STY_ID payment_type_id,
3533: ocf.DUE_ARREARS_YN Arrears_YN,
3534: cfl.FQY_CODE Frequency_Code,
3535: cfl.START_DATE,
3541: OKL_CASH_FLOWS ocf,
3542: OKL_CASH_FLOW_LEVELS cfl
3543: WHERE cfl.caf_id = ocf.ID
3544: AND ocf.CFO_ID = cfo.ID
3545: AND cfo.SOURCE_TABLE = 'OKL_ASSETS_B'
3546: AND cfo.OTY_CODE = 'QUOTED_ASSET_PROPERTY_TAX'
3547: AND cfo.SOURCE_ID = p_ast_id;
3548:
3549: --Get quote level payment details
3585: --cursor to fetch total trade in amount and description
3586: CURSOR get_ti_amt(p_qte_id IN okl_lease_quotes_b.ID%TYPE) IS
3587: SELECT sum(cdj.value) total_tradein
3588: FROM OKL_COST_ADJUSTMENTS_b cdj,
3589: OKL_ASSETS_B ast
3590: WHERE cdj.parent_object_id = ast.id
3591: AND cdj.parent_object_code = 'ASSET'
3592: AND cdj.adjustment_source_type = 'TRADEIN'
3593: AND ast.parent_object_id = p_qte_id
3596: --cursor to fetch trade in description for any one asset
3597: CURSOR get_ti_desc(p_qte_id IN okl_lease_quotes_b.ID%TYPE) IS
3598: SELECT cdj.description
3599: FROM OKL_COST_ADJUSTMENTS_V cdj,
3600: OKL_ASSETS_B ast
3601: WHERE cdj.parent_object_id = ast.id
3602: AND cdj.parent_object_code = 'ASSET'
3603: AND cdj.adjustment_source_type = 'TRADEIN'
3604: AND ast.parent_object_id = p_qte_id