[Home] [Help]
1202: -- Cursor Declarations for fetching the Lease Quote ID
1203: CURSOR get_ass_lq_id_csr( p_ast_id NUMBER )
1204: IS
1205: SELECT ast.parent_object_id lq_id
1206: FROM okl_assets_b ast
1207: WHERE ast.id = p_ast_id;
1208: CURSOR get_fee_lq_id_csr( p_fee_id NUMBER )
1209: IS
1210: SELECT fee.parent_object_id lq_id
6402: IS
6403: SELECT target_arrears,
6404: target_amount,
6405: parent_object_id
6406: FROM OKL_ASSETS_B
6407: WHERE id = p_astId;
6408: -- Cursor to fetch the Details from the Asset
6409: CURSOR fee_details_csr( p_feeId NUMBER )
6410: IS
6613: RAISE OKL_API.G_EXCEPTION_ERROR;
6614: END IF;
6615: l_cash_flow_det_tbl(1).number_of_periods := quote_rec.term / l_months_factor;
6616: --l_cash_flow_det_tbl(1).amount has been already fetched from the
6617: -- target_amount column either from OKL_LEASE_QUOTES_B/OKL_ASSETS_B/OKL_FEES_B
6618: ELSE
6619: -- When the LQ is being priced for SM pricng method, on selecting the SRT
6620: -- as the pricing option, the user will be shown to enter the Cash flow levels too.
6621: -- Hence, retrieve the cash flow levels even when the pricing option is SRT.
6755: p_init_msg_list => p_init_msg_list,
6756: x_return_status => l_return_status,
6757: x_msg_count => x_msg_count,
6758: x_msg_data => x_msg_data,
6759: p_cf_source_type => p_cf_source, -- Pass the source type OKL_ASSETS_B/OKL_LEASE_QUOTES_B
6760: p_qq_id => p_id, -- Pass the id of the Assets/ Lease Quote !
6761: x_days_in_month => x_days_in_month,
6762: x_days_in_year => x_days_in_year,
6763: x_cash_flow_rec => l_cash_flow_rec, -- Cash Flow Record
8288: ast.oec_percentage oec_percentage,
8289: ast.structured_pricing structured_pricing,
8290: ast.rate_template_id rate_template_id,
8291: ast.target_arrears target_arrears
8292: FROM okl_assets_b ast,
8293: okl_lease_quotes_b qte
8294: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
8295: ast.parent_object_id = qte.id AND
8296: qte.id = qteid;
8589: ast.lease_rate_factor lease_rate_factor,
8590: ast.asset_number name,
8591: ast.target_frequency target_frequency,
8592: ast.target_arrears target_arrears
8593: FROM okl_assets_b ast,
8594: okl_lease_quotes_b qte
8595: WHERE ast.parent_object_code = 'LEASEQUOTE'
8596: AND ast.parent_object_id = qte.id
8597: AND qte.id = qteid
8629: ast.oec_percentage,
8630: cmp.unit_cost,
8631: cmp.number_of_units,
8632: cmp.primary_component
8633: FROM okl_assets_b ast,
8634: okl_lease_quotes_b qte,
8635: okl_asset_components_b cmp
8636: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
8637: ast.parent_object_id = qte.id AND
8648: adj.basis,
8649: -- Start : DJANASWA : Bug# 6347118
8650: nvl(adj.value,adj.default_subsidy_amount) value
8651: -- End : DJANASWA : Bug# 6347118
8652: FROM okl_assets_b ast,
8653: okl_lease_quotes_b qte,
8654: okl_cost_adjustments_b adj
8655: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
8656: ast.parent_object_id = qte.id AND
9595: ELSE
9596: l_cashflow_header_rec.parent_object_code := 'QUOTED_ASSET';
9597: FOR t_rec IN check_cfo_exists_csr(
9598: p_oty_code => 'QUOTED_ASSET',
9599: p_source_table => 'OKL_ASSETS_B',
9600: p_source_id => p_ast_id)
9601: LOOP
9602: l_cfo_exists := t_rec.cfo_exists;
9603: l_sty_id := t_rec.sty_id;
10301: CURSOR all_assets_csr( p_qte_id IN okl_lease_quotes_b.id%TYPE)
10302: IS
10303: SELECT ast.id ast_id,
10304: ast.asset_number ast_number
10305: FROM okl_assets_b ast,
10306: okl_lease_quotes_b qte
10307: WHERE ast.parent_object_code = 'LEASEQUOTE'
10308: AND ast.parent_object_id = qte.id
10309: AND qte.id = p_qte_id;
10308: AND ast.parent_object_id = qte.id
10309: AND qte.id = p_qte_id;
10310: all_assets_rec all_assets_csr%ROWTYPE;
10311: -- Cursor to fetch the payment structure defined/derieved of an asset
10312: CURSOR ast_payments_csr( p_ast_id OKL_ASSETS_B.ID%TYPE,
10313: p_qte_id OKL_LEASE_QUOTES_B.ID%TYPE)
10314: IS
10315: SELECT cfl.fqy_code frequency,
10316: caf.due_arrears_yn adv_arrears,
10320: cfl.stub_days,
10321: cfl.stub_amount,
10322: cfl.number_of_periods periods,
10323: cfl.amount periodic_amount
10324: FROM okl_assets_b ast,
10325: okl_cash_flow_objects cfo,
10326: okl_cash_flows caf,
10327: okl_cash_flow_levels cfl,
10328: okl_strm_type_b sty
10330: AND ast.parent_object_id = p_qte_id
10331: AND cfo.source_id = ast.id
10332: AND caf.cfo_id = cfo.id
10333: AND cfl.caf_id = caf.id
10334: AND cfo.source_table = 'OKL_ASSETS_B'
10335: AND cfo.oty_code = 'QUOTED_ASSET'
10336: AND caf.sts_code IN ( 'CURRENT', 'WORK')
10337: AND caf.sty_id = sty.id
10338: AND sty.stream_type_purpose = 'RENT'
10564: qte.expected_delivery_date line_end_date,
10565: ast.lease_rate_factor lease_rate_factor,
10566: ast.target_arrears target_arrears,
10567: ast.oec_percentage oec_percentage
10568: FROM okl_assets_b ast,
10569: okl_lease_quotes_b qte
10570: WHERE ast.parent_object_code = 'LEASEQUOTE'
10571: AND ast.parent_object_id = qte.id
10572: AND qte.id = qteid
10604: ast.oec_percentage,
10605: cmp.unit_cost,
10606: cmp.number_of_units,
10607: cmp.primary_component
10608: FROM okl_assets_b ast,
10609: okl_lease_quotes_b qte,
10610: okl_asset_components_b cmp
10611: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
10612: ast.parent_object_id = qte.id AND
10623: adj.basis,
10624: -- Start : DJANASWA : Bug# 6347118
10625: nvl(adj.value,adj.default_subsidy_amount) value
10626: -- End : DJANASWA : Bug# 6347118
10627: FROM okl_assets_b ast,
10628: okl_lease_quotes_b qte,
10629: okl_cost_adjustments_b adj
10630: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
10631: ast.parent_object_id = qte.id AND
14296: -- Need to delete the cash flow (if any exists) for this Asset with WORK Status.
14297: l_cfo_exists_at_noa := 'YES';
14298: FOR t_rec IN check_cfo_exists_csr(
14299: p_oty_code => 'QUOTED_ASSET',
14300: p_source_table => 'OKL_ASSETS_B',
14301: p_source_id => l_non_overiding_assets_tbl(t),
14302: p_sts_code => 'WORK')
14303: LOOP
14304: l_cfo_exists_at_noa := t_rec.cfo_exists;