DBA Data[Home] [Help]

APPS.OKL_INS_QUOTE_PVT dependencies on OKL_INS_EXCLUSIONS_B

Line 4411: FROM OKL_INS_EXCLUSIONS_B

4407:
4408: --- Cursor For Restrition country and asset
4409: CURSOR okl_country_restriction (p_country_code VARCHAR2, p_asset_category NUMBER) IS
4410: SELECT 'x'
4411: FROM OKL_INS_EXCLUSIONS_B
4412: WHERE COUNTRY_ID = p_country_code
4413: AND COLL_CODE = p_asset_category;
4414:
4415: --- Cursor For Restrition and asset categor and SIC CODE

Line 4419: FROM OKL_INS_EXCLUSIONS_B

4415: --- Cursor For Restrition and asset categor and SIC CODE
4416: CURSOR okl_country_restriction (p_country_code VARCHAR2, p_asset_category NUMBER
4417: ,p_sic_code VARCHAR2) IS
4418: SELECT 'x'
4419: FROM OKL_INS_EXCLUSIONS_B
4420: WHERE COUNTRY_ID = p_country_code
4421: AND COLL_CODE = p_asset_category
4422: AND SIC_CODE = p_sic_code;
4423: