APPS.OE_CREATE_ACCOUNT_INFO dependencies on HZ_LOCATIONS

Line 5825: FROM hz_locations loc,

5821:
5822:
5823: CURSOR c_party_site_id(in_sold_to_party_id number) IS
5824: SELECT site.party_site_id
5825: FROM hz_locations loc,
5826: hz_party_sites site
5827: WHERE site.location_id=loc.location_id
5828: and site.party_id=in_sold_to_party_id
5829: and loc.address1 = p_site_address1

Line 5850: HZ_LOCATIONS LOC

5846: /*
5847: cursor C1(in_sold_to_party_id number) IS
5848: SELECT site.party_site_id
5849: FROM HZ_PARTY_SITES SITE,
5850: HZ_LOCATIONS LOC
5851: WHERE site.location_id=loc.location_id
5852: and site.status='A'
5853: and loc.ADDRESS1 = p_site_address1
5854: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =

Line 5879: FROM hz_locations loc,

5875: and rel.status='A');
5876: */
5877: CURSOR c2 IS
5878: SELECT site.party_site_id
5879: FROM hz_locations loc,
5880: hz_party_sites site
5881: WHERE site.location_id=loc.location_id
5882: and site.status='A'
5883: and loc.address1 = p_site_address1

Line 5949: FROM hz_locations loc,

5945: END IF;
5946:
5947: SELECT site.party_site_id
5948: INTO l_id
5949: FROM hz_locations loc,
5950: hz_party_sites site
5951: WHERE loc.ADDRESS1 = p_site_address1
5952: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =
5953: nvl( p_site_address2, fnd_api.g_miss_char)

Line 5999: FROM hz_locations loc,

5995: END IF;
5996:
5997: SELECT site.party_site_id
5998: INTO l_id
5999: FROM hz_locations loc,
6000: hz_party_sites site
6001: WHERE loc.ADDRESS1 = p_site_address1
6002: AND nvl( loc.ADDRESS2, fnd_api.g_miss_char) =
6003: nvl( p_site_address2, fnd_api.g_miss_char)