APPS.QP_PREQ_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 14612: FROM hz_cust_site_uses_all hsu

14608: /* begin changes made for tracking bug 2693700 */
14609: BEGIN
14610: SELECT NVL(gsa_indicator, 'N')
14611: INTO l_gsa_indicator_flag
14612: FROM hz_cust_site_uses_all hsu
14613: WHERE site_use_id = OE_ORDER_PUB.G_HDR.invoice_to_org_id
14614: AND NVL(hsu.org_id,
14615: NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'), 1, 1), ' ', NULL,
14616: SUBSTRB(USERENV('CLIENT_INFO'), 1, 10))), - 99)) =