APPS.CSD_REFURBISH_IRO_GRP dependencies on HZ_PARTY_SITES

Line 107: From Hz_Party_Sites hps,

103: Select hpsu.party_site_use_id,
104: hps.party_id
105: Into x_party_site_use_id,
106: x_party_id
107: From Hz_Party_Sites hps,
108: Hz_Party_Site_uses hpsu,
109: Hz_Locations hl
110: Where hps.party_site_id = x_party_site_id
111: And hpsu.site_use_type = p_site_use_type