DBA Data[Home] [Help]

APPS.AHL_PRD_DISPOSITION_PVT dependencies on CS_INCIDENT_SEVERITIES_VL

Line 3529: SELECT incident_severity_id from cs_incident_severities_vl

3525: SELECT workorder_operation_id from ahl_workorder_operations
3526: WHERE workorder_id = p_workorder_id AND operation_sequence_num = p_operation_seq;
3527:
3528: CURSOR severity_id_csr(p_severity_name IN VARCHAR2) IS
3529: SELECT incident_severity_id from cs_incident_severities_vl
3530: WHERE name = p_severity_name
3531: AND incident_subtype = 'INC'
3532: AND trunc(sysdate) between trunc(nvl(start_date_active,sysdate)) and trunc(nvl(end_date_active,sysdate));
3533: