DBA Data[Home] [Help]

APPS.PJM_INQUIRY dependencies on HZ_CUST_ACCT_SITES_ALL

Line 332: , hz_cust_acct_sites_all acct_site

328: INTO L_Org_Address
329: FROM hz_cust_site_uses_all site
330: , hz_locations loc
331: , hz_party_sites party_site
332: , hz_cust_acct_sites_all acct_site
333: WHERE site.site_use_id = X_Org_ID
334: AND site.cust_acct_site_id = acct_site.cust_acct_site_id
335: AND acct_site.party_site_id = party_site.party_site_id
336: AND party_site.location_id = loc.location_id

Line 348: , hz_cust_acct_sites_all acct_site

344: INTO L_Org_Address
345: FROM hz_cust_site_uses_all site
346: , hz_locations loc
347: , hz_party_sites party_site
348: , hz_cust_acct_sites_all acct_site
349: WHERE site.site_use_id = X_Org_ID
350: AND site.cust_acct_site_id = acct_site.cust_acct_site_id
351: AND acct_site.party_site_id = party_site.party_site_id
352: AND party_site.location_id = loc.location_id