DBA Data[Home] [Help]

APPS.AHL_WARRANTY_ENTL_PVT dependencies on CS_INCIDENTS_ALL_B

Line 1754: FROM CS_INCIDENTS_ALL_B

1750: AND claim_status_code <> 'CANCELLED';
1751:
1752: CURSOR chk_incident_id_csr (c_incident_id NUMBER) IS
1753: SELECT 'X'
1754: FROM CS_INCIDENTS_ALL_B
1755: WHERE incident_id = c_incident_id
1756: AND incident_status_id <> 2; -- Closed status
1757:
1758: CURSOR chk_visit_tsk_id_csr (c_task_id NUMBER) IS