1206:
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'
1261:
1262:
1263: CURSOR c_prim_party_site_use(in_party_site_id in number,in_site_use_type in varchar2) IS
1264: SELECT party_site_use_id
1265: FROM hz_party_site_uses
1266: where party_site_id=in_party_site_id and
1267: site_use_type=in_site_use_type and
1268: primary_per_type='Y'
1269: and status='A';
1272: /*cc project*/
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
4650: END IF;
4651: begin
4652: select party_site_id
4653: into p_party_site_id
4654: from hz_party_site_uses
4655: where party_site_use_id=p_party_site_use_id;
4656:
4657: EXCEPTION
4658:
5289: begin
5290:
5291: select party_site_id
5292: into p_site_id
5293: from hz_party_site_uses
5294: where party_site_use_id=p_site_use_id
5295: and status='A';
5296:
5297: EXCEPTION