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 496: SUBTYPE cflv_rec_type IS okl_cash_flow_levels_pub.cflv_rec_type;

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

Line 859: SUBTYPE cflv_rec_type IS okl_cash_flow_levels_pub.cflv_rec_type;

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

Line 1498: FROM okl_cash_flows caf, okl_cash_flow_levels cfl

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

Line 2197: FROM okl_cash_flows caf, okl_cash_flow_levels cfl

2193: -- get the payment lines for a given object
2194: CURSOR l_currpymtlines_csr(cp_obj_id IN NUMBER) IS
2195: SELECT caf.sty_id, caf.due_arrears_yn, cfl.start_date, caf.number_of_advance_periods, cfl.amount,
2196: cfl.number_of_periods, cfl.fqy_code, cfl.level_Sequence, cfl.stub_days, cfl.stub_amount
2197: FROM okl_cash_flows caf, okl_cash_flow_levels cfl
2198: WHERE caf.id = cfl.caf_id
2199: AND caf.cfo_id = cp_obj_id
2200: ORDER BY caf.sty_id, cfl.start_date;
2201: