DBA Data[Home] [Help]

APPS.WSH_TPA_SELECTOR_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 196: hz_cust_site_uses_all site_uses

192: CURSOR Get_Ece_Loc_Code (v_site_use_id NUMBER) IS-- TCA View Removal starts
193: SELECT Acct_site.Ece_tp_location_code,
194: Acct_site.Tp_header_id /* TP_HEADER_ID */
195: FROM hz_cust_acct_sites_all acct_site ,
196: hz_cust_site_uses_all site_uses
197: WHERE site_uses.site_use_id = v_site_use_id AND
198: acct_site.cust_acct_site_id/*address-id*/ = site_uses.cust_acct_site_id; -- TCA View Removal ends
199:
200: