APPS.OE_CREATE_ACCOUNT_INFO dependencies on HZ_PARTY_SITE_USES

Line 1208: FROM hz_party_site_uses site_use,

1204:
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'

Line 1263: FROM hz_party_site_uses

1259:
1260:
1261: CURSOR c_prim_party_site_use(in_party_site_id in number,in_site_use_type in varchar2) IS
1262: SELECT party_site_use_id
1263: FROM hz_party_site_uses
1264: where party_site_id=in_party_site_id and
1265: site_use_type=in_site_use_type and
1266: primary_per_type='Y'
1267: and status='A';

Line 1274: FROM hz_party_site_uses site_use,

1270: /*cc project*/
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

Line 4652: from hz_party_site_uses

4648: END IF;
4649: begin
4650: select party_site_id
4651: into p_party_site_id
4652: from hz_party_site_uses
4653: where party_site_use_id=p_party_site_use_id;
4654:
4655: EXCEPTION
4656:

Line 5291: from hz_party_site_uses

5287: begin
5288:
5289: select party_site_id
5290: into p_site_id
5291: from hz_party_site_uses
5292: where party_site_use_id=p_site_use_id
5293: and status='A';
5294:
5295: EXCEPTION