[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
6735: IS
6736: SELECT target_arrears,
6737: target_amount,
6738: parent_object_id
6739: FROM OKL_ASSETS_B
6740: WHERE id = p_astId;
6741: -- Cursor to fetch the Details from the Asset
6742: CURSOR fee_details_csr( p_feeId NUMBER )
6743: IS
6946: RAISE OKL_API.G_EXCEPTION_ERROR;
6947: END IF;
6948: l_cash_flow_det_tbl(1).number_of_periods := quote_rec.term / l_months_factor;
6949: --l_cash_flow_det_tbl(1).amount has been already fetched from the
6950: -- target_amount column either from OKL_LEASE_QUOTES_B/OKL_ASSETS_B/OKL_FEES_B
6951: ELSE
6952: -- When the LQ is being priced for SM pricng method, on selecting the SRT
6953: -- as the pricing option, the user will be shown to enter the Cash flow levels too.
6954: -- Hence, retrieve the cash flow levels even when the pricing option is SRT.
7089: p_init_msg_list => p_init_msg_list,
7090: x_return_status => l_return_status,
7091: x_msg_count => x_msg_count,
7092: x_msg_data => x_msg_data,
7093: p_cf_source_type => p_cf_source, -- Pass the source type OKL_ASSETS_B/OKL_LEASE_QUOTES_B
7094: p_qq_id => p_id, -- Pass the id of the Assets/ Lease Quote !
7095: x_days_in_month => x_days_in_month,
7096: x_days_in_year => x_days_in_year,
7097: x_cash_flow_rec => l_cash_flow_rec, -- Cash Flow Record
8622: ast.oec_percentage oec_percentage,
8623: ast.structured_pricing structured_pricing,
8624: ast.rate_template_id rate_template_id,
8625: ast.target_arrears target_arrears
8626: FROM okl_assets_b ast,
8627: okl_lease_quotes_b qte
8628: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
8629: ast.parent_object_id = qte.id AND
8630: qte.id = qteid;
8927: ast.lease_rate_factor lease_rate_factor,
8928: ast.asset_number name,
8929: ast.target_frequency target_frequency,
8930: ast.target_arrears target_arrears
8931: FROM okl_assets_b ast,
8932: okl_lease_quotes_b qte
8933: WHERE ast.parent_object_code = 'LEASEQUOTE'
8934: AND ast.parent_object_id = qte.id
8935: AND qte.id = qteid
8969: ast.oec_percentage,
8970: cmp.unit_cost,
8971: cmp.number_of_units,
8972: cmp.primary_component
8973: FROM okl_assets_b ast,
8974: okl_lease_quotes_b qte,
8975: okl_asset_components_b cmp
8976: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
8977: ast.parent_object_id = qte.id AND
8988: adj.basis,
8989: -- Start : DJANASWA : Bug# 6347118
8990: nvl(adj.value,adj.default_subsidy_amount) value
8991: -- End : DJANASWA : Bug# 6347118
8992: FROM okl_assets_b ast,
8993: okl_lease_quotes_b qte,
8994: okl_cost_adjustments_b adj
8995: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
8996: ast.parent_object_id = qte.id AND
9938: ELSE
9939: l_cashflow_header_rec.parent_object_code := 'QUOTED_ASSET';
9940: FOR t_rec IN check_cfo_exists_csr(
9941: p_oty_code => 'QUOTED_ASSET',
9942: p_source_table => 'OKL_ASSETS_B',
9943: p_source_id => p_ast_id)
9944: LOOP
9945: l_cfo_exists := t_rec.cfo_exists;
9946: l_sty_id := t_rec.sty_id;
10841: CURSOR all_assets_csr( p_qte_id IN okl_lease_quotes_b.id%TYPE)
10842: IS
10843: SELECT ast.id ast_id,
10844: ast.asset_number ast_number
10845: FROM okl_assets_b ast,
10846: okl_lease_quotes_b qte
10847: WHERE ast.parent_object_code = 'LEASEQUOTE'
10848: AND ast.parent_object_id = qte.id
10849: AND qte.id = p_qte_id;
10848: AND ast.parent_object_id = qte.id
10849: AND qte.id = p_qte_id;
10850: all_assets_rec all_assets_csr%ROWTYPE;
10851: -- Cursor to fetch the payment structure defined/derieved of an asset
10852: CURSOR ast_payments_csr( p_ast_id OKL_ASSETS_B.ID%TYPE,
10853: p_qte_id OKL_LEASE_QUOTES_B.ID%TYPE)
10854: IS
10855: SELECT cfl.fqy_code frequency,
10856: caf.due_arrears_yn adv_arrears,
10860: cfl.stub_days,
10861: cfl.stub_amount,
10862: cfl.number_of_periods periods,
10863: cfl.amount periodic_amount
10864: FROM okl_assets_b ast,
10865: okl_cash_flow_objects cfo,
10866: okl_cash_flows caf,
10867: okl_cash_flow_levels cfl,
10868: okl_strm_type_b sty
10870: AND ast.parent_object_id = p_qte_id
10871: AND cfo.source_id = ast.id
10872: AND caf.cfo_id = cfo.id
10873: AND cfl.caf_id = caf.id
10874: AND cfo.source_table = 'OKL_ASSETS_B'
10875: AND cfo.oty_code = 'QUOTED_ASSET'
10876: AND caf.sts_code IN ( 'CURRENT', 'WORK')
10877: AND caf.sty_id = sty.id
10878: AND sty.stream_type_purpose = 'RENT'
11544: qte.expected_delivery_date line_end_date,
11545: ast.lease_rate_factor lease_rate_factor,
11546: ast.target_arrears target_arrears,
11547: ast.oec_percentage oec_percentage
11548: FROM okl_assets_b ast,
11549: okl_lease_quotes_b qte
11550: WHERE ast.parent_object_code = 'LEASEQUOTE'
11551: AND ast.parent_object_id = qte.id
11552: AND qte.id = qteid
11598: ast.oec_percentage,
11599: cmp.unit_cost,
11600: cmp.number_of_units,
11601: cmp.primary_component
11602: FROM okl_assets_b ast,
11603: okl_lease_quotes_b qte,
11604: okl_asset_components_b cmp
11605: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
11606: ast.parent_object_id = qte.id AND
11617: adj.basis,
11618: -- Start : DJANASWA : Bug# 6347118
11619: nvl(adj.value,adj.default_subsidy_amount) value
11620: -- End : DJANASWA : Bug# 6347118
11621: FROM okl_assets_b ast,
11622: okl_lease_quotes_b qte,
11623: okl_cost_adjustments_b adj
11624: WHERE ast.parent_object_code = 'LEASEQUOTE' AND
11625: ast.parent_object_id = qte.id AND
15550: -- Need to delete the cash flow (if any exists) for this Asset with WORK Status.
15551: l_cfo_exists_at_noa := 'YES';
15552: FOR t_rec IN check_cfo_exists_csr(
15553: p_oty_code => 'QUOTED_ASSET',
15554: p_source_table => 'OKL_ASSETS_B',
15555: p_source_id => l_non_overiding_assets_tbl(t),
15556: p_sts_code => 'WORK')
15557: LOOP
15558: l_cfo_exists_at_noa := t_rec.cfo_exists;