[Home] [Help]
APPS.OKL_SSC_WF dependencies on OKL_INS_CLAIMS_B
Line 2774: FROM OKL_INS_POLICIES_B IPYB, OKL_INS_CLAIMS_B ICMB
2770:
2771:
2772: CURSOR claim_info(claim_id VARCHAR2) IS
2773: SELECT IPYB.POLICY_NUMBER , ICMB.CLAIM_NUMBER
2774: FROM OKL_INS_POLICIES_B IPYB, OKL_INS_CLAIMS_B ICMB
2775: WHERE IPYB.ID = ICMB.IPY_ID
2776: AND ICMB.ID = claim_id;
2777:
2778: