APPS.ARI_SELF_REGISTRATION_PKG dependencies on HZ_CUST_SITE_USES

Line 871: select site_uses.site_use_id INTO l_site_use_id FROM hz_cust_site_uses site_uses

867:
868: select user_name INTO l_user_name FROM fnd_user where user_id = l_user_id;
869:
870: if(p_cust_acct_site_id <> -1) then
871: select site_uses.site_use_id INTO l_site_use_id FROM hz_cust_site_uses site_uses
872: where site_uses.cust_acct_site_id = p_cust_acct_site_id
873: and site_uses.site_use_code = 'BILL_TO';
874: else -- This is being done to signify All Locations record
875: l_site_use_id := -1;

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 1337: from hz_cust_site_uses

1333: END IF;
1334:
1335: select cust_acct_site_id
1336: into l_cust_acct_site_id
1337: from hz_cust_site_uses
1338: where site_use_id = p_cust_site_use_id;
1339:
1340: l_debug_info:='In GetCustAcctSiteId'||l_cust_acct_site_id;
1341: IF (PG_DEBUG = 'Y') THEN