APPS.CSD_REFURBISH_IRO_GRP dependencies on HZ_PARTY_SITE_USES

Line 108: Hz_Party_Site_uses hpsu,

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
112: And hps.status = C_Site_Status_Active