APPS.OE_GSA_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 159: from hz_cust_site_uses_all hsu

155: --added the following select and assignment statement to fix bug 1738379 Begin
156: l_invoice_to_org_id := p_line_rec.invoice_to_org_id;
157: select /* MOAC_SQL_CHANGE */ nvl(gsa_indicator,'N')
158: into l_gsa_flag
159: from hz_cust_site_uses_all hsu
160: where site_use_id = l_invoice_to_org_id ;
161: /* AND NVL(hsu.org_id,
162: NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1 ,1), ' ',NULL,
163: SUBSTRB(USERENV('CLIENT_INFO'), 1,10))),-99)) =