APPS.OE_CREATE_ACCOUNT_INFO dependencies on HZ_LOCATIONS

Line 5823: FROM hz_locations loc,

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

Line 5848: HZ_LOCATIONS LOC

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

Line 5877: FROM hz_locations loc,

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

Line 5947: FROM hz_locations loc,

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

Line 5997: FROM hz_locations loc,

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