APPS.CS_SR_DUP_CHK_PVT dependencies on HZ_PARTY_SITES

Line 358: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link, hz_party_sites sites

354: sr_link.end_date_active(+) is null and
355: sr_link.LAST_UPDATE_DATE(+) > l_duplicate_date
356: UNION
357: SELECT sr.INCIDENT_ID, sr.INCIDENT_NUMBER, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
358: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link, hz_party_sites sites
359: WHERE sr.INCIDENT_LOCATION_ID = sites.party_site_id AND
360: sr.incident_location_type = 'HZ_PARTY_SITE' AND
361: sites.location_id = loc.location_id AND
362: nvl(upper(loc.ADDRESS1||decode(loc.address2,null,null,';'||loc.address2) ||decode(loc.address3,null,null,';'||loc.address3)||decode(loc.address4,null,null,';'||loc.address4)), 'Not Filled') =

Line 434: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link, hz_party_sites sites

430: sr_link.end_date_active(+) is null and
431: sr_link.LAST_UPDATE_DATE(+) > l_duplicate_date
432: UNION
433: SELECT sr.INCIDENT_ID, sr.INCIDENT_NUMBER, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
434: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link, hz_party_sites sites
435: WHERE sr.INCIDENT_LOCATION_ID = sites.party_site_id AND
436: sr.incident_location_type = 'HZ_PARTY_SITE' AND
437: sites.location_id = loc.location_id AND
438: nvl(upper(loc.ADDRESS1||decode(loc.address2,null,null,';'||loc.address2) ||decode(loc.address3,null,null,';'||loc.address3)||decode(loc.address4,null,null,';'||loc.address4)), 'Not Filled') =