APPS.CS_SR_DUP_CHK_PVT dependencies on CUG_SR_TYPE_ATTR_MAPS_VL

Line 491: select SR_ATTRIBUTE_CODE from CUG_SR_TYPE_ATTR_MAPS_VL

487:
488: l_IncidentId_withAddrUpd_rec l_IncidentId_withAddrUpd_csr%ROWTYPE;
489:
490: CURSOR l_DuplicateCheckAttrs_csr IS
491: select SR_ATTRIBUTE_CODE from CUG_SR_TYPE_ATTR_MAPS_VL
492: where INCIDENT_TYPE_ID = l_incident_type_id AND
493: SR_ATTR_DUP_CHECK_FLAG = 'Y' AND
494: ( END_DATE_ACTIVE IS NULL OR
495: to_number(to_char(END_DATE_ACTIVE, 'YYYYMMDD')) >= to_number(to_char(sysdate, 'YYYYMMDD')) );