[Home] [Help]
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
1211: FROM okl_fees_b fee
1212: WHERE fee.id = p_fee_id;
1213:
1214: -- Local Variables
1215: l_api_version CONSTANT NUMBER DEFAULT 1.0;
6411: SELECT target_arrears,
6412: target_amount,
6413: parent_object_id,
6414: payment_type_id
6415: FROM OKL_FEES_B
6416: WHERE id = p_feeId;
6417: -- Cursor to fetch the Cash flow header information
6418: CURSOR lq_cash_flows_csr( p_id NUMBER, p_cf_source_type VARCHAR2 )
6419: 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.
6708: IF p_cf_source = G_CF_SOURCE_LQ_FEE
6709: THEN
6710: -- For Rollover/Financed fee, though the PM is TR, where LLO is not applicable
6711: -- there also, pricing will fetch Adv/Arrears, Rate, Frequency will be fetched
6712: -- from the quote, but the Payment Stream ID will be store in the okl_fees_b.payment_sty_id
6713: FOR t_rec IN fee_details_csr( p_id )
6714: LOOP
6715: l_cash_flow_rec.sty_id := t_rec.payment_type_id;
6716: END LOOP;
8563: CURSOR fees_csr(qteid NUMBER,
8564: fee_id NUMBER)
8565: IS
8566: SELECT stytl.name
8567: FROM okl_fees_b fee,
8568: okl_strm_type_tl stytl
8569: WHERE fee.parent_object_code = 'LEASEQUOTE'
8570: AND fee.parent_object_id = qteid
8571: AND fee.id = fee_id
8608: fee.lease_rate_factor lease_rate_factor,
8609: fee.fee_type || ' FEE' name,
8610: fee.target_frequency target_frequency,
8611: fee.target_arrears target_arrears
8612: FROM okl_fees_b fee,
8613: okl_lease_quotes_b qte
8614: WHERE fee.parent_object_code = 'LEASEQUOTE'
8615: AND fee.parent_object_id = qte.id
8616: AND qte.id = qteid
9585: THEN
9586: l_cashflow_header_rec.parent_object_code := 'QUOTED_FEE';
9587: FOR t_rec IN check_cfo_exists_csr(
9588: p_oty_code => 'QUOTED_FEE',
9589: p_source_table => 'OKL_FEES_B',
9590: p_source_id => p_ast_id)
9591: LOOP
9592: l_cfo_exists := t_rec.cfo_exists;
9593: l_sty_id := t_rec.sty_id;
10115: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
10116: '!!!!! Fetching the Expense Cash flows for fee type ' || p_fee_type );
10117: FOR t_rec IN lq_cash_flows_csr(
10118: p_id => p_fee_id,
10119: p_cf_source => 'OKL_FEES_B',
10120: p_cft_code => 'OUTFLOW_SCHEDULE')
10121: LOOP
10122: x_outflow_caf_rec.caf_id := t_rec.caf_id;
10123: x_outflow_caf_rec.khr_id := t_rec.khr_id;
10182: '!!!!! Fetching the Income Cash flows for fee type ' || p_fee_type );
10183: l_return_status := OKL_API.G_RET_STS_ERROR;
10184: FOR t_rec IN lq_cash_flows_csr(
10185: p_id => p_fee_id,
10186: p_cf_source => 'OKL_FEES_B',
10187: p_cft_code => 'PAYMENT_SCHEDULE')
10188: LOOP
10189: x_inflow_caf_rec.caf_id := t_rec.caf_id;
10190: x_inflow_caf_rec.khr_id := t_rec.khr_id;
10583: fee.effective_to line_end_date,
10584: fee.lease_rate_factor lease_rate_factor,
10585: fee.target_arrears target_arrears,
10586: NULL oec_percentage
10587: FROM okl_fees_b fee,
10588: okl_lease_quotes_b qte
10589: WHERE fee.parent_object_code = 'LEASEQUOTE'
10590: AND fee.parent_object_id = qte.id
10591: AND qte.id = qteid;