APPS.OE_CREATE_ACCOUNT_INFO dependencies on HZ_PARTY_SITES

Line 1211: hz_party_sites site

1207:
1208: CURSOR c_party_site_use(in_party_site_use_id in number) IS
1209: SELECT site_use.site_use_type,site_use.party_site_id,site_use.primary_per_type
1210: FROM hz_party_site_uses site_use,
1211: hz_party_sites site
1212: WHERE party_site_use_id = in_party_site_use_id
1213: AND site.party_site_id = site_use.party_site_id
1214: AND site.status = 'A'
1215: AND site_use.status='A';

Line 1219: FROM hz_party_sites

1215: AND site_use.status='A';
1216:
1217: CURSOR c_party_site(in_party_site_id in number) IS
1218: SELECT party_id,status
1219: FROM hz_party_sites
1220: WHERE party_site_id = in_party_site_id;
1221:
1222:
1223: CURSOR c_acct_site(in_cust_account_id in number

Line 1258: FROM hz_party_sites

1254:
1255: /*cc project*/
1256: CURSOR c_get_party_sites(in_party_id in number) IS
1257: SELECT party_site_id
1258: FROM hz_party_sites
1259: where party_id = in_party_id
1260: and status='A';
1261:
1262:

Line 1277: hz_party_sites site

1273: --{added for bug 4240715
1274: CURSOR c_endcust_party_site_use(in_party_site_id in number,in_site_use_type in varchar2) IS
1275: SELECT site_use.party_site_use_id
1276: FROM hz_party_site_uses site_use,
1277: hz_party_sites site
1278: WHERE party_site_use_id = site_use.party_site_use_id
1279: AND site.party_site_id = in_party_site_id
1280: AND site_use.site_use_type =in_site_use_type
1281: AND site.status = 'A'

Line 4698: from hz_party_sites

4694: END IF;
4695: begin
4696: select party_id
4697: into p_party_id
4698: from hz_party_sites
4699: where party_site_id=p_party_site_id;
4700:
4701: EXCEPTION
4702:

Line 5341: from hz_party_sites s

5337: END IF;
5338: begin
5339: select s.party_id
5340: into p_party_id
5341: from hz_party_sites s
5342: where s.party_site_id=p_site_id
5343: and s.status='A';
5344:
5345: IF l_debug_level > 0 THEN

Line 5570: from hz_party_sites s

5566: END IF;
5567: begin
5568: select s.party_id
5569: into p_party_id
5570: from hz_party_sites s
5571: where s.party_site_id=p_site_id
5572: and s.status='A';
5573:
5574: IF l_debug_level > 0 THEN

Line 5826: hz_party_sites site

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
5830: and nvl( loc.address2, fnd_api.g_miss_char) =

Line 5849: FROM HZ_PARTY_SITES SITE,

5845:
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

Line 5880: hz_party_sites site

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
5884: and nvl( loc.address2, fnd_api.g_miss_char) =

Line 5950: hz_party_sites site

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)
5954: AND nvl( loc.ADDRESS3, fnd_api.g_miss_char) =

Line 6000: hz_party_sites site

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)
6004: AND nvl( loc.ADDRESS3, fnd_api.g_miss_char) =