eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_INS_RATES

Line 1642: FROM OKL_INS_POLICIES_B IPYB , OKL_INS_RATES INR

1638:
1639:
1640: CURSOR c_ins_opt_premium (p_covered_amount IN NUMBER) IS
1641: SELECT ((INSURER_RATE * p_covered_amount )/100 )
1642: FROM OKL_INS_POLICIES_B IPYB , OKL_INS_RATES INR
1643: WHERE IPYB.ipt_id = inr.ipt_id AND
1644: kle_id = p_ipyv_rec.KLE_ID and
1645: khr_id = p_ipyv_rec.KHR_ID
1646: AND IPYB.date_from between inr.date_FROM and DECODE(NVL(inr.date_TO,NULL),NULL,SYSDATE, inr.date_TO)

Line 2952: FROM OKL_INS_POLICIES_B IPYB , OKL_INS_RATES INR

2948: WHERE name = cp_name
2949: AND language = cp_language;
2950: CURSOR c_ins_opt_premium (p_covered_amount IN NUMBER) IS
2951: SELECT ((INSURER_RATE * p_covered_amount )/100 )
2952: FROM OKL_INS_POLICIES_B IPYB , OKL_INS_RATES INR
2953: WHERE IPYB.ipt_id = inr.ipt_id AND
2954: kle_id = p_ipyv_rec.KLE_ID and
2955: khr_id = p_ipyv_rec.KHR_ID
2956: AND IPYB.date_from between inr.date_FROM and DECODE(NVL(inr.date_TO,NULL),NULL,SYSDATE, inr.date_TO)