DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKL_COST_ADJUSTMENTS_V

Line 3203: FROM OKL_COST_ADJUSTMENTS_V

3199: ,short_description
3200: ,description
3201: ,comments
3202: ,percent_basis_value
3203: FROM OKL_COST_ADJUSTMENTS_V
3204: WHERE parent_object_id = p_ast_id
3205: AND parent_object_code = 'ASSET'
3206: AND adjustment_source_type = 'DOWN_PAYMENT';
3207:

Line 3352: FROM OKL_COST_ADJUSTMENTS_V

3348: ,short_description
3349: ,description
3350: ,comments
3351: ,percent_basis_value
3352: FROM OKL_COST_ADJUSTMENTS_V
3353: WHERE parent_object_id = p_ast_id
3354: AND parent_object_code = 'ASSET'
3355: AND adjustment_source_type = 'TRADEIN';
3356:

Line 3500: l_ti_desc OKL_COST_ADJUSTMENTS_V.description%TYPE;

3496: lx_rulv_tbl okl_la_payments_pvt.rulv_tbl_type;
3497: l_payment_type_id Number;
3498: l_eot_type VARCHAR2(40);
3499: l_ti_amt NUMBER := NULL;
3500: l_ti_desc OKL_COST_ADJUSTMENTS_V.description%TYPE;
3501:
3502: --sechawla 7-dec-09 9120203 : begin
3503: --get the corporate book from system options
3504: cursor l_corp_book_csr IS

Line 3650: FROM OKL_COST_ADJUSTMENTS_V cdj,

3646:
3647: --cursor to fetch trade in description for any one asset
3648: CURSOR get_ti_desc(p_qte_id IN okl_lease_quotes_b.ID%TYPE) IS
3649: SELECT cdj.description
3650: FROM OKL_COST_ADJUSTMENTS_V cdj,
3651: OKL_ASSETS_B ast
3652: WHERE cdj.parent_object_id = ast.id
3653: AND cdj.parent_object_code = 'ASSET'
3654: AND cdj.adjustment_source_type = 'TRADEIN'