APPS.CS_SR_DUP_CHK_PVT dependencies on CUG_SR_TYPE_ATTR_MAPS_VL

Line 475: select SR_ATTRIBUTE_CODE from CUG_SR_TYPE_ATTR_MAPS_VL

471:
472: l_IncidentId_withAddrUpd_rec l_IncidentId_withAddrUpd_csr%ROWTYPE;
473:
474: CURSOR l_DuplicateCheckAttrs_csr IS
475: select SR_ATTRIBUTE_CODE from CUG_SR_TYPE_ATTR_MAPS_VL
476: where INCIDENT_TYPE_ID = l_incident_type_id AND
477: SR_ATTR_DUP_CHECK_FLAG = 'Y' AND
478: ( END_DATE_ACTIVE IS NULL OR
479: to_number(to_char(END_DATE_ACTIVE, 'YYYYMMDD')) >= to_number(to_char(sysdate, 'YYYYMMDD')) );