APPS.RLM_EXTINTERFACE_SV dependencies on HZ_PARTY_SITES

Line 2133: HZ_PARTY_SITES PARTY_SITE,

2129: -- Following query is changed as per TCA obsolescence project.
2130: select loc.address1
2131: into v_address1
2132: from HZ_CUST_SITE_USES_ALL cust_site,
2133: HZ_PARTY_SITES PARTY_SITE,
2134: HZ_LOCATIONS LOC,
2135: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
2136: where cust_site.site_use_code = 'SHIP_TO'
2137: and cust_site.site_use_id = x_OrgId