DBA Data[Home] [Help]

APPS.OKL_VAR_INT_REAMORT_PVT dependencies on OKL_TIME_UNITS_V

Line 743: l_frequency okl_time_units_v.name%type;

739: l_rbk_tbl_cntr NUMBER := 0;
740: l_rent_tbl OKL_VARIABLE_INTEREST_PVT.csm_periodic_expenses_tbl_type;
741: l_csm_loan_level_tbl OKL_VARIABLE_INTEREST_PVT.csm_loan_level_tbl_type;
742: --l_split_asset_tbl strm_lalevl_tbl;
743: l_frequency okl_time_units_v.name%type;
744: l_adder_months NUMBER;
745: l_payment_level_start_date DATE;
746: l_reamort_date DATE;
747: l_date_last_int_cal DATE;

Line 804: Cursor get_pmt_freq (l_freq in okl_time_units_v.name%type) is

800: and rgpb.cle_id = p_cle_id
801: and rgpb.rgd_code = 'LALEVL'
802: order by to_number(sll_rulb.rule_information1); -- 4899594
803:
804: Cursor get_pmt_freq (l_freq in okl_time_units_v.name%type) is
805: select id1 from okl_time_units_v
806: where name = l_freq;
807:
808: CURSOR c_last_int_cur (p_contract_id NUMBER) IS

Line 805: select id1 from okl_time_units_v

801: and rgpb.rgd_code = 'LALEVL'
802: order by to_number(sll_rulb.rule_information1); -- 4899594
803:
804: Cursor get_pmt_freq (l_freq in okl_time_units_v.name%type) is
805: select id1 from okl_time_units_v
806: where name = l_freq;
807:
808: CURSOR c_last_int_cur (p_contract_id NUMBER) IS
809: SELECT NVL(date_last_interim_interest_cal, start_date) reamort_date