APPS.OZF_CLAIM_PVT dependencies on HZ_LOCATIONS

Line 726: -- location_id is the primary key for hz_locations.

722: FROM hz_cust_site_uses
723: WHERE site_use_id = p_site_use_id;
724:
725: --based on ship to site if found, else bill to site.
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

Line 740: FROM hz_locations

736: l_location_id number;
737:
738: CURSOR location_info_csr(p_location_id in number) is
739: SELECT city, county, country, postal_code, state, province
740: FROM hz_locations
741: WHERE location_id = p_location_id;
742:
743: BEGIN
744: -- Initialize API return status to sucess