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 6393: OKL_CASH_FLOWS cfh,

6389: cfh.id caf_id,
6390: cfo.id cfo_id,
6391: cfh.sty_id stream_type_id
6392: FROM OKL_CASH_FLOW_LEVELS cfl,
6393: OKL_CASH_FLOWS cfh,
6394: OKL_CASH_FLOW_OBJECTS cfo
6395: WHERE cfl.caf_id = cfh.id
6396: AND cfh.cfo_id = cfo.id
6397: AND cfo.source_table = 'OKL_LEASE_QUOTES_B'

Line 6431: FROM OKL_CASH_FLOWS cf,

6427: ,due_arrears_yn due_arrears_yn
6428: ,start_date start_date
6429: ,number_of_advance_periods number_of_advance_periods
6430: ,oty_code oty_code
6431: FROM OKL_CASH_FLOWS cf,
6432: OKL_CASH_FLOW_OBJECTS cfo
6433: WHERE cf.cfo_id = cfo.id
6434: AND cfo.source_table = p_cf_source_type
6435: AND cfo.source_id = p_id;

Line 8707: OKL_CASH_FLOWS caf

8703: cfo.id cfo_id,
8704: caf.id caf_id,
8705: caf.sty_id sty_id
8706: FROM OKL_CASH_FLOW_OBJECTS cfo,
8707: OKL_CASH_FLOWS caf
8708: WHERE OTY_CODE = p_oty_code
8709: AND SOURCE_TABLE = p_source_table
8710: AND SOURCE_ID = p_source_id
8711: AND caf.cfo_id = cfo.id;

Line 10057: FROM OKL_CASH_FLOWS cf,

10053: ,due_arrears_yn due_arrears_yn
10054: ,start_date start_date
10055: ,number_of_advance_periods number_of_advance_periods
10056: ,cfo.oty_code oty_code
10057: FROM OKL_CASH_FLOWS cf,
10058: OKL_CASH_FLOW_OBJECTS cfo
10059: WHERE cf.cfo_id = cfo.id
10060: AND cfo.source_table = p_cf_source
10061: AND cfo.source_id = p_id

Line 10326: okl_cash_flows caf,

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
10329: WHERE ast.id = p_ast_id
10330: AND ast.parent_object_id = p_qte_id

Line 10682: OKL_CASH_FLOWS caf

10678: SELECT 'YES' cfo_exists,
10679: cfo.id cfo_id,
10680: caf.id caf_id
10681: FROM OKL_CASH_FLOW_OBJECTS cfo,
10682: OKL_CASH_FLOWS caf
10683: WHERE OTY_CODE = p_oty_code
10684: AND SOURCE_TABLE = p_source_table
10685: AND SOURCE_ID = p_source_id
10686: AND caf.cfo_id = cfo.id;