DBA Data[Home] [Help]

APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_TIME_UNITS_V

Line 8910: l_frequency okl_time_units_v.name%type;

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;

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

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

Line 8971: select id1 from okl_time_units_v

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