DBA Data[Home] [Help]

APPS.ARI_SELF_REGISTRATION_PKG dependencies on HZ_CUST_SITE_USES

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

1259: BEGIN
1260:
1261: select cust_acct_site_id
1262: into l_cust_acct_site_id
1263: from hz_cust_site_uses
1264: where site_use_id = p_cust_site_use_id;
1265:
1266: return l_cust_acct_site_id;
1267: