790: -- location_id is the primary key for hz_locations.
791: --to get location_id (verify the sqls)
792: CURSOR location_id_csr(p_site_id in number) IS
793: SELECT ps.location_id 794: FROM hz_party_sites ps 795: , hz_cust_acct_sites ac
796: , hz_cust_site_uses su
797: WHERE ps.party_site_id = ac.party_site_id
798: AND ac.cust_acct_site_id = su.cust_acct_site_id