APPS.CSM_SR_EVENT_PKG dependencies on HZ_PARTY_SITES

Line 891: (select location_id from hz_party_sites where party_site_id = NVL(csi.incident_location_id, csi.install_site_id)),

887: csi.incident_location_id,
888: csi.customer_id party_id,
889: decode(nvl(csi.incident_location_type,'HZ_PARTY_SITE'),
890: 'HZ_PARTY_SITE',
891: (select location_id from hz_party_sites where party_site_id = NVL(csi.incident_location_id, csi.install_site_id)),
892: 'HZ_LOCATION',
893: (select location_id from hz_locations where location_id = NVL(csi.incident_location_id, csi.install_site_id))
894: ) location_id ,
895: nvl(csi.incident_location_type,'HZ_PARTY_SITE') incident_location_type,

Line 1140: (select location_id from hz_party_sites where party_site_id = NVL(csi.incident_location_id, csi.install_site_id)),

1136: csi.incident_location_id,
1137: csi.customer_id party_id,
1138: decode(nvl(csi.incident_location_type,'HZ_PARTY_SITE'),
1139: 'HZ_PARTY_SITE',
1140: (select location_id from hz_party_sites where party_site_id = NVL(csi.incident_location_id, csi.install_site_id)),
1141: 'HZ_LOCATION',
1142: (select location_id from hz_locations where location_id = NVL(csi.incident_location_id, csi.install_site_id))
1143: ) location_id ,
1144: nvl(csi.incident_location_type,'HZ_PARTY_SITE') incident_location_type,

Line 1373: (select location_id from hz_party_sites where party_site_id = NVL(csi.incident_location_id, csi.install_site_id)),

1369: csi.incident_location_id,
1370: csi.customer_id party_id,
1371: decode(nvl(csi.incident_location_type,'HZ_PARTY_SITE'),
1372: 'HZ_PARTY_SITE',
1373: (select location_id from hz_party_sites where party_site_id = NVL(csi.incident_location_id, csi.install_site_id)),
1374: 'HZ_LOCATION',
1375: (select location_id from hz_locations where location_id = NVL(csi.incident_location_id, csi.install_site_id))
1376: ) location_id ,
1377: nvl(csi.incident_location_type,'HZ_PARTY_SITE') incident_location_type,