DBA Data[Home] [Help]

APPS.AHL_PRD_DISPOSITION_PVT dependencies on CS_INCIDENT_SEVERITIES_VL

Line 3962: SELECT incident_severity_id from cs_incident_severities_vl

3958: SELECT workorder_operation_id from ahl_workorder_operations
3959: WHERE workorder_id = p_workorder_id AND operation_sequence_num = p_operation_seq;
3960:
3961: CURSOR severity_id_csr(p_severity_name IN VARCHAR2) IS
3962: SELECT incident_severity_id from cs_incident_severities_vl
3963: WHERE name = p_severity_name
3964: AND incident_subtype = 'INC'
3965: AND trunc(sysdate) between trunc(nvl(start_date_active,sysdate)) and trunc(nvl(end_date_active,sysdate));
3966: