APPS.IBE_ADDRESS_V2PVT dependencies on HZ_LOCATIONS

Line 279: from hz_locations

275: ORDER BY party_site_use_id DESC;
276:
277: CURSOR c_get_location_ovn(l_location_id VARCHAR2) IS
278: Select object_version_number
279: from hz_locations
280: where location_id = l_location_id;
281:
282: BEGIN
283:

Line 1280: FROM hz_party_sites ps, hz_party_site_uses psu, hz_locations loc, hr_organization_information hr

1276: l_contact_org_id NUMBER;
1277:
1278: cursor c_getPrimAddrId_2(l_party_id NUMBER,l_org_id NUMBER,hr_type VARCHAR2,site_type VARCHAR2) IS
1279: SELECT ps.party_site_id
1280: FROM hz_party_sites ps, hz_party_site_uses psu, hz_locations loc, hr_organization_information hr
1281: WHERE
1282: ps.party_id = l_party_id AND
1283: ps.status = 'A' AND
1284: ps.location_id = loc.location_id AND

Line 2142: FROM hz_locations

2138: END IF;
2139:
2140: BEGIN
2141: SELECT location_id INTO l_dummy
2142: FROM hz_locations
2143: WHERE location_id = p_location.location_id
2144: AND nvl(address1, l_gmiss) = nvl(p_location.address1, l_gmiss)
2145: AND nvl(address2, l_gmiss) = nvl(p_location.address2, l_gmiss)
2146: AND nvl(address3, l_gmiss) = nvl(p_location.address3, l_gmiss)

Line 2307: IS SELECT country FROM hz_locations

2303: l_psite_terr_code VARCHAR2(30);
2304: l_flag BOOLEAN;
2305:
2306: CURSOR c1(l_c_party_site_id IN NUMBER)
2307: IS SELECT country FROM hz_locations
2308: WHERE location_id IN
2309: (SELECT location_id FROM hz_party_sites
2310: WHERE party_site_id = l_c_party_site_id);
2311: