DBA Data[Home] [Help]

APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_INS_POLICIES_ALL_B

Line 171: FROM okl_ins_policies_all_b ins

167: CURSOR c_insurance_csr (l_khr_id NUMBER)
168: IS
169: SELECT ins.policy_number
170: ,ins.ipe_code
171: FROM okl_ins_policies_all_b ins
172: WHERE ins.khr_id = l_khr_id
173: AND ins.ipy_type = 'LEASE_POLICY'
174: AND ins.quote_yn = 'N'
175: AND ins.iss_code = 'ACTIVE';