8906: l_rbk_tbl_cntr NUMBER := 0;
8907: l_rent_tbl csm_periodic_expenses_tbl_type;
8908: l_csm_loan_level_tbl csm_loan_level_tbl_type;
8909: --l_split_asset_tbl strm_lalevl_tbl;
8910: l_frequency okl_time_units_v.name%type;
8911: l_adder_months NUMBER;
8912: l_payment_level_start_date DATE;
8913: l_reamort_date DATE;
8914: l_date_last_int_cal DATE;
8966: and rgpb.cle_id = p_cle_id
8967: and rgpb.rgd_code = 'LALEVL'
8968: order by to_number(sll_rulb.rule_information1); -- 4899594
8969:
8970: Cursor get_pmt_freq (l_freq in okl_time_units_v.name%type) is
8971: select id1 from okl_time_units_v
8972: where name = l_freq;
8973:
8974: CURSOR c_last_int_cur (p_contract_id NUMBER) IS
8967: and rgpb.rgd_code = 'LALEVL'
8968: order by to_number(sll_rulb.rule_information1); -- 4899594
8969:
8970: Cursor get_pmt_freq (l_freq in okl_time_units_v.name%type) is
8971: select id1 from okl_time_units_v
8972: where name = l_freq;
8973:
8974: CURSOR c_last_int_cur (p_contract_id NUMBER) IS
8975: SELECT NVL(date_last_interim_interest_cal, start_date) reamort_date