APPS.OKL_AM_CALC_QUOTE_PYMNT_PVT dependencies on OKL_CASH_FLOW_LEVELS

Line 10: g_cflv_tbl_type okl_cash_flow_levels_pub.cflv_tbl_type;

6: --Define it globally, keep populating the table of records and finally make a
7: --call to bulk insert procedure
8: g_cfov_tbl_type okl_cash_flow_objects_pub.cfov_tbl_type;
9: g_cafv_tbl_type okl_cash_flows_pub.cafv_tbl_type;
10: g_cflv_tbl_type okl_cash_flow_levels_pub.cflv_tbl_type;
11: g_qcov_tbl_type okl_trx_qte_cf_objects_pub.qcov_tbl_type;
12: gx_cfov_tbl_type okl_cash_flow_objects_pub.cfov_tbl_type;
13: gx_cafv_tbl_type okl_cash_flows_pub.cafv_tbl_type;
14: gx_cflv_tbl_type okl_cash_flow_levels_pub.cflv_tbl_type;

Line 14: gx_cflv_tbl_type okl_cash_flow_levels_pub.cflv_tbl_type;

10: g_cflv_tbl_type okl_cash_flow_levels_pub.cflv_tbl_type;
11: g_qcov_tbl_type okl_trx_qte_cf_objects_pub.qcov_tbl_type;
12: gx_cfov_tbl_type okl_cash_flow_objects_pub.cfov_tbl_type;
13: gx_cafv_tbl_type okl_cash_flows_pub.cafv_tbl_type;
14: gx_cflv_tbl_type okl_cash_flow_levels_pub.cflv_tbl_type;
15: gx_qcov_tbl_type okl_trx_qte_cf_objects_pub.qcov_tbl_type;
16: g_cfov_counter NUMBER := 0;
17: g_cafv_counter NUMBER := 0;
18: g_cflv_counter NUMBER := 0;

Line 111: , okl_cash_flow_levels cfl

107: , caf.dnz_khr_id khr_id
108: , (nvl(sum(amount * number_of_periods),0) + nvl(sum(stub_amount),0)) Total
109: FROM okl_cash_flows caf
110: , okl_strm_type_b stm
111: , okl_cash_flow_levels cfl
112: WHERE dnz_qte_id = cp_qte_id
113: AND caf.sty_id = stm.id
114: AND caf.id = cfl.caf_id
115: AND caf.sts_code IN ( G_CURRENT_STATUS, G_PROPOSED_STATUS)

Line 495: SUBTYPE cflv_rec_type IS okl_cash_flow_levels_pub.cflv_rec_type;

491: | SubType Declarations
492: +-----------------------------------------------------------------------*/
493:
494: SUBTYPE cafv_rec_type IS okl_cash_flows_pub.cafv_rec_type;
495: SUBTYPE cflv_rec_type IS okl_cash_flow_levels_pub.cflv_rec_type;
496:
497: /*-----------------------------------------------------------------------+
498: | Local Variable Declarations and initializations |
499: +-----------------------------------------------------------------------*/

Line 858: SUBTYPE cflv_rec_type IS okl_cash_flow_levels_pub.cflv_rec_type;

854: +-----------------------------------------------------------------------*/
855:
856: SUBTYPE cfov_rec_type IS okl_cash_flow_objects_pub.cfov_rec_type;
857: SUBTYPE cafv_rec_type IS okl_cash_flows_pub.cafv_rec_type;
858: SUBTYPE cflv_rec_type IS okl_cash_flow_levels_pub.cflv_rec_type;
859: SUBTYPE qcov_rec_type IS okl_trx_qte_cf_objects_pub.qcov_rec_type;
860:
861: /*-----------------------------------------------------------------------+
862: | Local Variable Declarations and initializations |

Line 1497: FROM okl_cash_flows caf, okl_cash_flow_levels cfl

1493: CURSOR l_cashflows_csr(cp_cfo_id IN NUMBER) IS
1494: -- SECHAWLA 20-SEP-04 3816891 : added nvl for due_arrears_yn
1495: SELECT caf.id, caf.sty_id, nvl(caf.due_arrears_yn, 'N') due_arrears_yn, cfl.start_date, caf.number_of_advance_periods,
1496: cfl.amount, cfl.number_of_periods, cfl.fqy_code, cfl.level_sequence, cfl.stub_days, cfl.stub_amount
1497: FROM okl_cash_flows caf, okl_cash_flow_levels cfl
1498: WHERE cfo_id = cp_cfo_id
1499: AND caf.id = cfl.caf_id
1500: AND caf.sts_code = G_CURRENT_STATUS
1501: AND caf.cft_code = G_CASH_FLOW_TYPE

Line 2189: FROM okl_cash_flows caf, okl_cash_flow_levels cfl

2185: -- get the payment lines for a given object
2186: CURSOR l_currpymtlines_csr(cp_obj_id IN NUMBER) IS
2187: SELECT caf.sty_id, caf.due_arrears_yn, cfl.start_date, caf.number_of_advance_periods, cfl.amount,
2188: cfl.number_of_periods, cfl.fqy_code, cfl.level_Sequence, cfl.stub_days, cfl.stub_amount
2189: FROM okl_cash_flows caf, okl_cash_flow_levels cfl
2190: WHERE caf.id = cfl.caf_id
2191: AND caf.cfo_id = cp_obj_id
2192: ORDER BY caf.sty_id, cfl.start_date;
2193: