DBA Data[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PVT dependencies on CS_INCIDENT_STATUSES_VL

Line 728: FROM cs_incident_statuses_vl

724:
725: -- added to fix bug# 8265902
726: CURSOR get_status_id (p_status_name IN VARCHAR2) IS
727: SELECT incident_status_id
728: FROM cs_incident_statuses_vl
729: WHERE incident_subtype = 'INC'
730: AND UPPER(name) = UPPER(p_status_name)
731: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
732: AND TRUNC(NVL(end_date_active, SYSDATE))