DBA Data[Home] [Help]

APPS.OKL_PRICING_UTILS_PVT dependencies on OKL_CASH_FLOW_OBJECTS

Line 1182: OKL_CASH_FLOW_OBJECTS cfo

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';

Line 1439: OKL_CASH_FLOW_OBJECTS cfo

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

Line 6394: OKL_CASH_FLOW_OBJECTS cfo

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'
6398: AND cfo.source_id = qteId

Line 6432: OKL_CASH_FLOW_OBJECTS cfo

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;
6436: -- Cursor to fetch the Cash Flow Details

Line 8706: FROM OKL_CASH_FLOW_OBJECTS cfo,

8702: SELECT 'YES' cfo_exists,
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

Line 10058: OKL_CASH_FLOW_OBJECTS cfo

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
10062: AND cf .cft_code = p_cft_code ;

Line 10325: okl_cash_flow_objects cfo,

10321: cfl.stub_amount,
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

Line 10681: FROM OKL_CASH_FLOW_OBJECTS cfo,

10677: IS
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