APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_CASH_FLOWS

Line 1181: FROM OKL_CASH_FLOWS cf,

1177: ,due_arrears_yn due_arrears_yn
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

Line 1438: FROM OKL_CASH_FLOWS cf,

1434: ,due_arrears_yn due_arrears_yn
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;

Line 6726: OKL_CASH_FLOWS cfh,

6722: cfh.id caf_id,
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'

Line 6764: FROM OKL_CASH_FLOWS cf,

6760: ,due_arrears_yn due_arrears_yn
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;

Line 9047: OKL_CASH_FLOWS caf

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
9051: AND caf.cfo_id = cfo.id;

Line 10402: FROM OKL_CASH_FLOWS cf,

10398: ,due_arrears_yn due_arrears_yn
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

Line 10597: FROM OKL_CASH_FLOWS cf,

10593: ,due_arrears_yn due_arrears_yn
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

Line 10866: okl_cash_flows caf,

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
10870: AND ast.parent_object_id = p_qte_id

Line 11199: OKL_CASH_FLOWS CFLOW

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:
11203: header_info_rec header_info_csr%ROWTYPE;

Line 11676: OKL_CASH_FLOWS caf

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
11680: AND caf.cfo_id = cfo.id;