APPS.ARW_SEARCH_CUSTOMERS dependencies on HZ_CUST_SITE_USES

Line 961: select org_id into l_org_id from hz_cust_site_uses where site_use_id = p_site_use_id;

957: p_customer_id := p_custsite_rec_tbl(l_curr_index).CustomerId;
958: p_site_use_id := p_custsite_rec_tbl(l_curr_index).SiteUseId;
959:
960: IF ( p_site_use_id is not null ) THEN
961: select org_id into l_org_id from hz_cust_site_uses where site_use_id = p_site_use_id;
962: END IF;
963: IF (p_is_internal_user='Y') THEN
964:
965: IF ( p_site_use_id is null and p_customer_id is not null) THEN

Line 1088: SELECT cust_acct_site_id into l_cust_acct_site_id FROM hz_cust_site_uses WHERE SITE_USE_ID = p_site_use_id;

1084: begin
1085:
1086:
1087: if(p_site_use_id is not null) then
1088: SELECT cust_acct_site_id into l_cust_acct_site_id FROM hz_cust_site_uses WHERE SITE_USE_ID = p_site_use_id;
1089: end if;
1090: if(p_cust_acct_site_id is not null) then
1091: l_cust_acct_site_id := p_cust_acct_site_id;
1092: end if;

Line 1094: SELECT SITE_USE_ID FROM hz_cust_site_uses WHERE cust_acct_site_id = l_cust_acct_site_id and SITE_USE_CODE = 'BILL_TO'

1090: if(p_cust_acct_site_id is not null) then
1091: l_cust_acct_site_id := p_cust_acct_site_id;
1092: end if;
1093: FOR account_assigned_site IN (
1094: SELECT SITE_USE_ID FROM hz_cust_site_uses WHERE cust_acct_site_id = l_cust_acct_site_id and SITE_USE_CODE = 'BILL_TO'
1095: )LOOP
1096: INSERT INTO ar_irec_user_acct_sites_all
1097: (SESSION_ID,CUSTOMER_ID,CUSTOMER_SITE_USE_ID,USER_ID,CURRENT_DATE,ORG_ID, CREATION_DATE)
1098: VALUES(p_session_id,p_customer_id,account_assigned_site.SITE_USE_ID,p_user_id,trunc(sysdate),p_org_id, trunc(sysdate));