APPS.QP_PREQ_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 14424: FROM hz_cust_site_uses_all hsu

14420: /* begin changes made for tracking bug 2693700 */
14421: BEGIN
14422: SELECT NVL(gsa_indicator, 'N')
14423: INTO l_gsa_indicator_flag
14424: FROM hz_cust_site_uses_all hsu
14425: WHERE site_use_id = OE_ORDER_PUB.G_HDR.invoice_to_org_id
14426: AND NVL(hsu.org_id,
14427: NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'), 1, 1), ' ', NULL,
14428: SUBSTRB(USERENV('CLIENT_INFO'), 1, 10))), - 99)) =