2369: CURSOR c_sr_primary_account_address(p_incident_id NUMBER, p_site_use_type VARCHAR2)
2370: IS
2371: select distinct
2372: hp.party_site_id
2373: from hz_party_sites_v hp,
2374: hz_parties hz,
2375: hz_cust_acct_sites_all hca,
2376: hz_cust_site_uses_all hcsu,
2377: cs_incidents_all_b cs