726: -- location_id is the primary key for hz_locations.
727: --to get location_id (verify the sqls)
728: CURSOR location_id_csr(p_site_id in number) IS
729: SELECT ps.location_id 730: FROM hz_party_sites ps 731: , hz_cust_acct_sites ac
732: , hz_cust_site_uses su
733: WHERE ps.party_site_id = ac.party_site_id
734: AND ac.cust_acct_site_id = su.cust_acct_site_id