DBA Data[Home] [Help]

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_INS_CLAIMS_B

Line 5719: From okl_ins_claims_B CLMB,

5715: -- Fetch count of unsubmitted Insurance claims for the insurance policies
5716: -- attached to assets of the contract.
5717: cursor chk_claims (c_khr_id NUMBER ,c_qte_eff_date DATE )is
5718: Select CLMB.ID,CLMB.claim_date
5719: From okl_ins_claims_B CLMB,
5720: OKL_INS_POLICIES_V IPYV
5721: WHERE CLMB.ipy_id = IPYV.id
5722: AND trunc(CLMB.claim_date) >= trunc(c_qte_eff_date)
5723: AND CLMB.CSU_CODE <> 'SUBMITTED'