APPS.EGO_ITEM_ORG_ASSIGN_PVT dependencies on ZX_INPUT_CLASSIFICATIONS_V

Line 262: FROM ZX_INPUT_CLASSIFICATIONS_V

258: --Bug 5662813
259: IF ( p_pur_tax_code IS NOT NULL AND G_P_TAX_CODE_CONTROL_LEVEL = 1 ) THEN
260: BEGIN
261: SELECT 1 INTO l_exists
262: FROM ZX_INPUT_CLASSIFICATIONS_V
263: WHERE tax_type not in ('AWT','OFFSET')
264: AND enabled_flag = 'Y'
265: AND sysdate between start_date_active and nvl(end_date_active,sysdate)
266: AND lookup_code = p_pur_tax_code

Line 454: FROM ZX_INPUT_CLASSIFICATIONS_V

450:
451: BEGIN
452: IF l_item_rec.purchasing_tax_code IS NOT NULL THEN
453: SELECT 1 INTO l_exists
454: FROM ZX_INPUT_CLASSIFICATIONS_V
455: WHERE lookup_code = l_item_rec.purchasing_tax_code
456: AND tax_type not in ('AWT','OFFSET')
457: AND enabled_flag = 'Y'
458: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)