[Home] [Help]
4616:
4617: -- To get insurance rate based on oec of asset_category insurance product , insurance class ,country, from date and payment frequency
4618: CURSOR okl_ins_rate_csr(p_location_code VARCHAR2, p_oec NUMBER, p_ipt_id NUMBER , p_ins_class VARCHAR2, p_from_date DATE, p_freq_factor NUMBER) IS
4619: SELECT ((INSURED_RATE * p_oec )/100 ) * p_freq_factor,((INSURER_RATE * p_oec )/100 ) * p_freq_factor
4620: FROM OKL_INS_RATES INR
4621: WHERE INR.IPT_ID = p_ipt_id
4622: AND INR.IAC_CODE = p_ins_class
4623: AND INR.IC_ID = p_location_code
4624: AND p_oec BETWEEN INR.FACTOR_RANGE_START AND INR.FACTOR_RANGE_END
5343:
5344:
5345: CURSOR okl_ins_rate_csr(p_territory_code VARCHAR2,p_covered_amount NUMBER, p_ipt_id NUMBER , p_from_date DATE, p_freq_factor NUMBER, p_fact_val NUMBER) IS
5346: SELECT ((INSURED_RATE * p_covered_amount )/100 ) * p_freq_factor
5347: FROM OKL_INS_RATES INR
5348: WHERE INR.IPT_ID = p_ipt_id AND
5349: p_fact_val BETWEEN INR.FACTOR_RANGE_START AND INR.FACTOR_RANGE_END AND
5350: p_from_date BETWEEN INR.DATE_FROM AND DECODE(INR.DATE_TO,NULL,p_from_date,INR.DATE_TO)
5351: AND IC_ID = p_territory_code;
6468:
6469: CURSOR okl_ins_rate_csr(p_territory_code VARCHAR2,
6470: p_ipt_id NUMBER , p_from_date DATE, p_fact_val NUMBER) IS
6471: SELECT INSURER_RATE/ INSURED_RATE
6472: FROM OKL_INS_RATES INR
6473: WHERE INR.IPT_ID = p_ipt_id AND
6474: p_fact_val BETWEEN INR.FACTOR_RANGE_START AND INR.FACTOR_RANGE_END AND
6475: p_from_date BETWEEN INR.DATE_FROM AND DECODE(INR.DATE_TO,NULL,p_from_date + 1,INR.DATE_TO)
6476: AND IC_ID = p_territory_code;