DBA Data[Home] [Help]

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 6725: FROM OKL_CASH_FLOW_LEVELS cfl,

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

Line 6781: FROM OKL_CASH_FLOW_LEVELS

6777: ,stub_amount
6778: ,number_of_periods
6779: ,amount
6780: ,start_date
6781: FROM OKL_CASH_FLOW_LEVELS
6782: WHERE caf_id = p_caf_id
6783: ORDER BY start_date;
6784: -- Local Variables declaration
6785: l_cash_flow_rec so_cash_flows_rec_type;

Line 10421: FROM OKL_CASH_FLOW_LEVELS

10417: ,stub_amount
10418: ,number_of_periods
10419: ,amount
10420: ,start_date
10421: FROM OKL_CASH_FLOW_LEVELS
10422: WHERE caf_id = p_caf_id
10423: ORDER BY start_date;
10424:
10425: l_api_version CONSTANT NUMBER DEFAULT 1.0;

Line 10615: FROM OKL_CASH_FLOW_LEVELS

10611: ,stub_amount
10612: ,number_of_periods
10613: ,amount
10614: ,start_date
10615: FROM OKL_CASH_FLOW_LEVELS
10616: WHERE caf_id = p_caf_id
10617: ORDER BY start_date;
10618:
10619: l_api_version CONSTANT NUMBER DEFAULT 1.0;

Line 10867: okl_cash_flow_levels cfl,

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