[Home] [Help]
1222: ,in_party_site_id in number
1223: ,in_site_use_code in varchar2) IS
1224: SELECT s.cust_acct_site_id,u.site_use_id,u.primary_flag
1225: FROM hz_cust_acct_sites s,
1226: hz_cust_site_uses_all u
1227: WHERE s.cust_account_id = in_cust_account_id
1228: AND s.party_site_id = in_party_site_id
1229: AND s.status(+) = 'A'
1230: AND u.cust_acct_site_id(+) = s.cust_acct_site_id
1236: SELECT uses.cust_acct_site_id,
1237: uses.status,
1238: uses.primary_flag,
1239: cust_site.cust_account_id
1240: FROM hz_cust_site_uses uses, hz_cust_acct_sites_all cust_site
1241: WHERE site_use_id = in_site_Use_id
1242: AND site_use_code = in_site_use_code
1243: AND cust_site.cust_acct_site_id = uses.cust_acct_site_id;
1244:
1244:
1245: CURSOR C_get_cust_from_site_use_id(l_site_use_Id NUMBER) IS
1246: SELECT a.cust_account_id
1247: FROM hz_cust_acct_sites_all a,
1248: hz_cust_site_uses b
1249: WHERE b.site_use_id=l_site_use_id
1250: and a.cust_acct_site_id=b.cust_acct_site_id
1251: and b.status = 'A';
1252:
4472:
4473: select s.cust_account_id
4474: into p_cust_account_id
4475: from hz_cust_acct_sites_all s,
4476: hz_cust_site_uses u
4477: where s.cust_acct_site_id=u.cust_acct_site_id
4478: and u.site_use_id=p_site_use_id;
4479:
4480: end if;
4736: END IF;
4737: begin
4738: select u.site_use_id
4739: into p_site_use_id
4740: from hz_cust_acct_sites s,hz_cust_site_uses_all u
4741: where s.party_site_id=p_party_site_id
4742: and s.cust_acct_site_id= u.cust_acct_site_id;
4743:
4744: EXCEPTION
5480: select a.party_id
5481: into p_party_id
5482: from hz_cust_accounts a,
5483: hz_cust_acct_sites s,
5484: hz_cust_site_uses_all u
5485: where u.site_use_id=p_account_site_use_id
5486: and u.cust_acct_site_id=s.cust_acct_site_id
5487: and s.cust_account_id=a.cust_account_id;
5488: