APPS.OKL_AUTO_INSURANCE_PVT dependencies on OKL_INS_PRODUCTS_B

Line 937: FROM OKL_INSURER_RANKINGS OIR,OKL_INS_PRODUCTS_B IPTB

933: l_okl_eli_policies_csr okl_eli_policies_csr%ROWTYPE;
934:
935: CURSOR okl_provider_csr(ls_country_code IN VARCHAR2, l_factor IN NUMBER) IS
936: SELECT OIR.RANKING_SEQ, OIR.ISU_ID
937: FROM OKL_INSURER_RANKINGS OIR,OKL_INS_PRODUCTS_B IPTB
938: WHERE OIR.ISU_ID = IPTB.ISU_ID
939: AND OIR.IC_CODE = ls_country_code
940: AND IPT_TYPE = 'LEASE_PRODUCT'
941: AND l_factor BETWEEN FACTOR_MIN AND FACTOR_MAX