DBA Data[Home] [Help]

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_INS_CLAIMS_B

Line 5726: From okl_ins_claims_B CLMB,

5722: -- Fetch count of unsubmitted Insurance claims for the insurance policies
5723: -- attached to assets of the contract.
5724: cursor chk_claims (c_khr_id NUMBER ,c_qte_eff_date DATE )is
5725: Select CLMB.ID,CLMB.claim_date
5726: From okl_ins_claims_B CLMB,
5727: OKL_INS_POLICIES_V IPYV
5728: WHERE CLMB.ipy_id = IPYV.id
5729: AND trunc(CLMB.claim_date) >= trunc(c_qte_eff_date)
5730: AND CLMB.CSU_CODE <> 'SUBMITTED'