APPS.MSD_SR_UTIL dependencies on HZ_PARTY_SITES

Line 1210: hz_party_sites hps,

1206:
1207: cursor c2 (p_repair_line_id in number) is
1208: select get_sr_zone_pk(hps.location_id, p_zone_filter)
1209: from cs_incidents_all_b cia,
1210: hz_party_sites hps,
1211: csd_repairs crp
1212: where crp.repair_line_id = p_repair_line_id
1213: and cia.incident_id = crp.incident_id
1214: and cia.install_site_id = hps.party_site_id (+);