DBA Data[Home] [Help]

APPS.OKL_INSURANCE_WF dependencies on OKL_INS_POLICIES_B

Line 107: FROM OKL_INS_POLICIES_B IPYB

103: -- gboomina Bug - 5128517 - End
104:
105: CURSOR okl_k_lease_policy_csr(p_khr_id IN NUMBER) IS
106: SELECT 'x'
107: FROM OKL_INS_POLICIES_B IPYB
108: WHERE IPYB.IPY_TYPE <> 'OPTIONAL_POLICY' AND
109: SYSDATE BETWEEN IPYB.DATE_FROM AND IPYB.DATE_TO
110: AND IPYB.KHR_ID = p_khr_id ;
111: