APPS.OZF_CLAIM_PVT dependencies on HZ_LOCATIONS

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

786: FROM hz_cust_site_uses
787: WHERE site_use_id = p_site_use_id;
788:
789: --based on ship to site if found, else bill to site.
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

Line 804: FROM hz_locations

800: l_location_id number;
801:
802: CURSOR location_info_csr(p_location_id in number) is
803: SELECT city, county, country, postal_code, state, province
804: FROM hz_locations
805: WHERE location_id = p_location_id;
806:
807: BEGIN
808: -- Initialize API return status to sucess