DBA Data[Home] [Help]

APPS.OKL_CONTRACT_INFO dependencies on OKL_INS_POLICIES_B

Line 1321: FROM OKL_INS_POLICIES_B IPYB

1317: IS
1318: -- Get If insurance has lapsed for a contract
1319: CURSOR insurance_date_to_csr(p_contract_id NUMBER) IS
1320: SELECT 'N'
1321: FROM OKL_INS_POLICIES_B IPYB
1322: WHERE IPYB.KHR_ID = p_contract_id
1323: AND IPYB.IPY_TYPE <> 'OPTIONAL_POLICY'
1324: AND IPYB.QUOTE_YN = 'N'
1325: AND IPYB.ISS_CODE = 'ACTIVE'