APPS.ARI_SELF_REGISTRATION_PKG dependencies on HZ_CUST_ACCT_SITES

Line 1234: from hz_cust_acct_sites hcas, hz_cust_site_uses hcsu

1230: BEGIN
1231:
1232: select hcas.party_site_id
1233: into l_party_site_id
1234: from hz_cust_acct_sites hcas, hz_cust_site_uses hcsu
1235: where hcas.cust_acct_site_id = hcsu.cust_acct_site_id
1236: and hcsu.site_use_id = p_cust_site_use_id;
1237:
1238: return l_party_site_id;

Line 2509: FROM hz_cust_acct_sites hcas

2505: x_return_status := 'N';
2506:
2507: SELECT count(cust_acct_site_id)
2508: INTO l_count_sites
2509: FROM hz_cust_acct_sites hcas
2510: WHERE hcaS.cust_account_id = p_customer_id;
2511:
2512: IF l_count_sites > 0 THEN
2513: x_return_status := 'Y';