APPS.ARI_SELF_REGISTRATION_PKG dependencies on HZ_CUST_ACCT_SITES

Line 1289: from hz_cust_acct_sites hcas, hz_cust_site_uses hcsu

1285:
1286:
1287: select hcas.party_site_id
1288: into l_party_site_id
1289: from hz_cust_acct_sites hcas, hz_cust_site_uses hcsu
1290: where hcas.cust_acct_site_id = hcsu.cust_acct_site_id
1291: and hcsu.site_use_id = p_cust_site_use_id;
1292:
1293: l_debug_info := 'In GetPartySiteId l_party_site_id value: '||l_party_site_id;

Line 3092: FROM hz_cust_acct_sites hcas

3088: x_return_status := 'N';
3089:
3090: SELECT count(cust_acct_site_id)
3091: INTO l_count_sites
3092: FROM hz_cust_acct_sites hcas
3093: WHERE hcaS.cust_account_id = p_customer_id;
3094:
3095: IF l_count_sites > 0 THEN
3096: x_return_status := 'Y';