[Home] [Help]
1178: ,start_date start_date
1179: ,number_of_advance_periods number_of_advance_periods
1180: ,oty_code oty_code
1181: FROM OKL_CASH_FLOWS cf,
1182: OKL_CASH_FLOW_OBJECTS cfo
1183: WHERE cf.cfo_id = cfo.id
1184: AND cfo.source_table = p_cf_source_type
1185: AND cfo.source_id = p_qq_id
1186: AND cf.sts_code = 'CURRENT';
1435: ,start_date start_date
1436: ,number_of_advance_periods number_of_advance_periods
1437: ,oty_code oty_code
1438: FROM OKL_CASH_FLOWS cf,
1439: OKL_CASH_FLOW_OBJECTS cfo
1440: WHERE cf.cfo_id = cfo.id
1441: AND cfo.source_table = 'OKL_QUICK_QUOTE_LINES_B'
1442: AND cfo.source_id = p_qq_line_id;
1443: -- Cursor to fetch the Cash Flow Details
6723: cfo.id cfo_id,
6724: cfh.sty_id stream_type_id
6725: FROM OKL_CASH_FLOW_LEVELS cfl,
6726: OKL_CASH_FLOWS cfh,
6727: OKL_CASH_FLOW_OBJECTS cfo
6728: WHERE cfl.caf_id = cfh.id
6729: AND cfh.cfo_id = cfo.id
6730: AND cfo.source_table = 'OKL_LEASE_QUOTES_B'
6731: AND cfo.source_id = qteId
6761: ,start_date start_date
6762: ,number_of_advance_periods number_of_advance_periods
6763: ,oty_code oty_code
6764: FROM OKL_CASH_FLOWS cf,
6765: OKL_CASH_FLOW_OBJECTS cfo
6766: WHERE cf.cfo_id = cfo.id
6767: AND cfo.source_table = p_cf_source_type
6768: AND cfo.source_id = p_id;
6769: -- Cursor to fetch the Cash Flow Details
9042: SELECT 'YES' cfo_exists,
9043: cfo.id cfo_id,
9044: caf.id caf_id,
9045: caf.sty_id sty_id
9046: FROM OKL_CASH_FLOW_OBJECTS cfo,
9047: OKL_CASH_FLOWS caf
9048: WHERE OTY_CODE = p_oty_code
9049: AND SOURCE_TABLE = p_source_table
9050: AND SOURCE_ID = p_source_id
10399: ,start_date start_date
10400: ,number_of_advance_periods number_of_advance_periods
10401: ,cfo.oty_code oty_code
10402: FROM OKL_CASH_FLOWS cf,
10403: OKL_CASH_FLOW_OBJECTS cfo
10404: WHERE cf.cfo_id = cfo.id
10405: AND cfo.source_table = p_cf_source
10406: AND cfo.source_id = p_id
10407: AND cf .cft_code = p_cft_code ;
10594: ,start_date start_date
10595: ,number_of_advance_periods number_of_advance_periods
10596: ,cfo.oty_code oty_code
10597: FROM OKL_CASH_FLOWS cf,
10598: OKL_CASH_FLOW_OBJECTS cfo
10599: WHERE cf.cfo_id = cfo.id
10600: AND cfo.source_table = p_cf_source
10601: AND cfo.source_id = p_id
10602: AND cf .cft_code = p_cft_code ;
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
10869: WHERE ast.id = p_ast_id
11188: AND LSE_QT.ID = p_quote_id;
11189:
11190: quote_det_rec get_quote_details_csr%ROWTYPE;
11191:
11192: CURSOR header_info_csr(p_cfo_id OKL_CASH_FLOW_OBJECTS.ID%TYPE) IS
11193: SELECT OTY_CODE,
11194: SOURCE_TABLE,
11195: SOURCE_ID,
11196: STY_ID,
11194: SOURCE_TABLE,
11195: SOURCE_ID,
11196: STY_ID,
11197: CFT_CODE
11198: FROM OKL_CASH_FLOW_OBJECTS CFLOW_OBJ,
11199: OKL_CASH_FLOWS CFLOW
11200: WHERE CFLOW.CFO_ID = CFLOW_OBJ.ID
11201: AND CFLOW_OBJ.ID = p_cfo_id;
11202:
11671: IS
11672: SELECT 'YES' cfo_exists,
11673: cfo.id cfo_id,
11674: caf.id caf_id
11675: FROM OKL_CASH_FLOW_OBJECTS cfo,
11676: OKL_CASH_FLOWS caf
11677: WHERE OTY_CODE = p_oty_code
11678: AND SOURCE_TABLE = p_source_table
11679: AND SOURCE_ID = p_source_id
11826: WHERE SOURCE_LINE_TYPE = 'ASSET'
11827: AND RELATED_LINE_TYPE = P_LINE_TYPE
11828: AND RELATED_LINE_ID = P_FEE_SRVC_ID;
11829:
11830: CURSOR GET_FEE_ID(P_CFO_ID OKL_CASH_FLOW_OBJECTS.ID%TYPE) IS
11831: SELECT SOURCE_ID
11832: FROM OKL_CASH_FLOW_OBJECTS
11833: WHERE ID = P_CFO_ID;
11834: -- Bug 7440199: Quote Streams ER: RGOOTY: End
11828: AND RELATED_LINE_ID = P_FEE_SRVC_ID;
11829:
11830: CURSOR GET_FEE_ID(P_CFO_ID OKL_CASH_FLOW_OBJECTS.ID%TYPE) IS
11831: SELECT SOURCE_ID
11832: FROM OKL_CASH_FLOW_OBJECTS
11833: WHERE ID = P_CFO_ID;
11834: -- Bug 7440199: Quote Streams ER: RGOOTY: End
11835: BEGIN
11836: l_return_status := OKL_API.G_RET_STS_SUCCESS;