APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_CASH_FLOW_LEVELS

Line 1199: FROM OKL_CASH_FLOW_LEVELS

1195: ,stub_amount
1196: ,number_of_periods
1197: ,amount
1198: ,start_date
1199: FROM OKL_CASH_FLOW_LEVELS
1200: WHERE caf_id = p_caf_id
1201: ORDER BY start_date;
1202: -- Cursor Declarations for fetching the Lease Quote ID
1203: CURSOR get_ass_lq_id_csr( p_ast_id NUMBER )

Line 1455: FROM OKL_CASH_FLOW_LEVELS

1451: ,stub_amount
1452: ,number_of_periods
1453: ,amount
1454: ,start_date
1455: FROM OKL_CASH_FLOW_LEVELS
1456: WHERE caf_id = p_caf_id
1457: ORDER BY start_date;
1458: -- Local Variables
1459: l_api_version CONSTANT NUMBER DEFAULT 1.0;

Line 6392: FROM OKL_CASH_FLOW_LEVELS cfl,

6388: SELECT cfl.ID cfl_id,
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

Line 6448: FROM OKL_CASH_FLOW_LEVELS

6444: ,stub_amount
6445: ,number_of_periods
6446: ,amount
6447: ,start_date
6448: FROM OKL_CASH_FLOW_LEVELS
6449: WHERE caf_id = p_caf_id
6450: ORDER BY start_date;
6451: -- Local Variables declaration
6452: l_cash_flow_rec so_cash_flows_rec_type;

Line 10075: FROM OKL_CASH_FLOW_LEVELS

10071: ,stub_amount
10072: ,number_of_periods
10073: ,amount
10074: ,start_date
10075: FROM OKL_CASH_FLOW_LEVELS
10076: WHERE caf_id = p_caf_id
10077: ORDER BY start_date;
10078:
10079: l_api_version CONSTANT NUMBER DEFAULT 1.0;

Line 10327: okl_cash_flow_levels cfl,

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
10331: AND cfo.source_id = ast.id