APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_INS_RATES

Line 1623: FROM OKL_INS_POLICIES_B IPYB , OKL_INS_RATES INR

1619:
1620:
1621: CURSOR c_ins_opt_premium (p_covered_amount IN NUMBER) IS
1622: SELECT ((INSURER_RATE * p_covered_amount )/100 )
1623: FROM OKL_INS_POLICIES_B IPYB , OKL_INS_RATES INR
1624: WHERE IPYB.ipt_id = inr.ipt_id AND
1625: kle_id = p_ipyv_rec.KLE_ID and
1626: khr_id = p_ipyv_rec.KHR_ID
1627: AND IPYB.date_from between inr.date_FROM and DECODE(NVL(inr.date_TO,NULL),NULL,SYSDATE, inr.date_TO)

Line 2933: FROM OKL_INS_POLICIES_B IPYB , OKL_INS_RATES INR

2929: WHERE name = cp_name
2930: AND language = cp_language;
2931: CURSOR c_ins_opt_premium (p_covered_amount IN NUMBER) IS
2932: SELECT ((INSURER_RATE * p_covered_amount )/100 )
2933: FROM OKL_INS_POLICIES_B IPYB , OKL_INS_RATES INR
2934: WHERE IPYB.ipt_id = inr.ipt_id AND
2935: kle_id = p_ipyv_rec.KLE_ID and
2936: khr_id = p_ipyv_rec.KHR_ID
2937: AND IPYB.date_from between inr.date_FROM and DECODE(NVL(inr.date_TO,NULL),NULL,SYSDATE, inr.date_TO)