APPS.AHL_WARRANTY_ENTL_PVT dependencies on AHL_WARRANTY_CLAIMS_B

Line 1748: FROM AHL_WARRANTY_CLAIMS_B

1744: AND NVL(end_date_active, SYSDATE + 1) > SYSDATE;
1745:
1746: CURSOR chk_claim_id_csr (c_claim_id NUMBER) IS
1747: SELECT 'X'
1748: FROM AHL_WARRANTY_CLAIMS_B
1749: WHERE warranty_claim_id = c_claim_id
1750: AND claim_status_code <> 'CANCELLED';
1751:
1752: CURSOR chk_incident_id_csr (c_incident_id NUMBER) IS