APPS.CSD_REFURBISH_IRO_GRP dependencies on CS_INCIDENT_STATUSES_VL

Line 647: From cs_incident_statuses_vl

643: End If;
644: End If;
645: Begin
646: Select incident_status_id Into l_inc_status_Id
647: From cs_incident_statuses_vl
648: Where incident_subtype = C_SR_SubType_INC
649: And seeded_flag = C_YES
650: And trunc(sysdate) between trunc(nvl(start_date_active,sysdate)) and trunc(nvl(end_date_active,sysdate))
651: And status_code = C_Status_Open ;