APPS.CS_SR_DUP_CHK_PVT dependencies on HZ_PARTY_SITES

Line 362: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link, hz_party_sites sites , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

358: sr_stat.DUP_CHK_FLAG = 'Y' and -- 12.1.2 - DUP CHECK
359: sr_link.LAST_UPDATE_DATE(+) > l_duplicate_date
360: UNION
361: SELECT sr.INCIDENT_ID, sr.INCIDENT_NUMBER, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
362: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link, hz_party_sites sites , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
363: WHERE sr.INCIDENT_LOCATION_ID = sites.party_site_id AND
364: sr.incident_location_type = 'HZ_PARTY_SITE' AND
365: sites.location_id = loc.location_id AND
366: 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 446: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link, hz_party_sites sites , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK

442: sr_stat.DUP_CHK_FLAG = 'Y' and -- 12.1.2 - DUP CHECK
443: sr_link.LAST_UPDATE_DATE(+) > l_duplicate_date
444: UNION
445: SELECT sr.INCIDENT_ID, sr.INCIDENT_NUMBER, sr_link.object_id incident_link_id, sr_link.object_number incident_link_number
446: FROM cs_incidents_b_sec sr, HZ_LOCATIONS loc, cs_incident_links sr_link, hz_party_sites sites , cs_incident_statuses_vl sr_stat -- 12.1.2 - DUP CHECK
447: WHERE sr.INCIDENT_LOCATION_ID = sites.party_site_id AND
448: sr.incident_location_type = 'HZ_PARTY_SITE' AND
449: sites.location_id = loc.location_id AND
450: 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') =