APPS.CUG_GENERIC_WF_PKG dependencies on CUG_SR_TYPE_ATTR_MAPS_VL

Line 644: select SR_ATTRIBUTE_CODE from CUG_SR_TYPE_ATTR_MAPS_VL

640: l_IncidentId_noLoc_rec l_IncidentId_noLoc_csr%ROWTYPE;
641:
642:
643: CURSOR l_DuplicateCheckAttrs_csr IS
644: select SR_ATTRIBUTE_CODE from CUG_SR_TYPE_ATTR_MAPS_VL
645: where INCIDENT_TYPE_ID = l_request_type_id AND
646: SR_ATTR_DUP_CHECK_FLAG = 'Y' AND
647: ( END_DATE_ACTIVE IS NULL OR
648: to_number(to_char(END_DATE_ACTIVE, 'YYYYMMDD')) >= to_number(to_char(sysdate, 'YYYYMMDD')) );