DBA Data[Home] [Help]

APPS.PJM_INQUIRY dependencies on HZ_CUST_ACCT_SITES_ALL

Line 342: , hz_cust_acct_sites_all acct_site

338: INTO L_Org_Address
339: FROM hz_cust_site_uses_all site
340: , hz_locations loc
341: , hz_party_sites party_site
342: , hz_cust_acct_sites_all acct_site
343: WHERE site.site_use_id = X_Org_ID
344: AND site.cust_acct_site_id = acct_site.cust_acct_site_id
345: AND acct_site.party_site_id = party_site.party_site_id
346: AND party_site.location_id = loc.location_id

Line 358: , hz_cust_acct_sites_all acct_site

354: INTO L_Org_Address
355: FROM hz_cust_site_uses_all site
356: , hz_locations loc
357: , hz_party_sites party_site
358: , hz_cust_acct_sites_all acct_site
359: WHERE site.site_use_id = X_Org_ID
360: AND site.cust_acct_site_id = acct_site.cust_acct_site_id
361: AND acct_site.party_site_id = party_site.party_site_id
362: AND party_site.location_id = loc.location_id