DBA Data[Home] [Help]

APPS.OE_CREATE_ACCOUNT_INFO dependencies on HZ_PARTY_SITES

Line 1209: hz_party_sites site

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

Line 1217: FROM hz_party_sites

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

Line 1256: FROM hz_party_sites

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

Line 1275: hz_party_sites site

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

Line 4696: from hz_party_sites

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

Line 5339: from hz_party_sites s

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

Line 5568: from hz_party_sites s

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

Line 5824: hz_party_sites site

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

Line 5847: FROM HZ_PARTY_SITES SITE,

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

Line 5878: hz_party_sites site

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

Line 5948: hz_party_sites site

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

Line 5998: hz_party_sites site

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