DBA Data[Home] [Help]

APPS.EGO_ITEM_ORG_ASSIGN_PVT dependencies on ZX_INPUT_CLASSIFICATIONS_V

Line 274: FROM ZX_INPUT_CLASSIFICATIONS_V

270: --Bug 5662813
271: IF ( p_pur_tax_code IS NOT NULL AND G_P_TAX_CODE_CONTROL_LEVEL = 1 ) THEN
272: BEGIN
273: SELECT 1 INTO l_exists
274: FROM ZX_INPUT_CLASSIFICATIONS_V
275: WHERE tax_type not in ('AWT','OFFSET')
276: AND enabled_flag = 'Y'
277: AND sysdate between start_date_active and nvl(end_date_active,sysdate)
278: AND lookup_code = p_pur_tax_code

Line 474: FROM ZX_INPUT_CLASSIFICATIONS_V

470:
471: BEGIN
472: IF l_item_rec.purchasing_tax_code IS NOT NULL THEN
473: SELECT 1 INTO l_exists
474: FROM ZX_INPUT_CLASSIFICATIONS_V
475: WHERE lookup_code = l_item_rec.purchasing_tax_code
476: AND tax_type not in ('AWT','OFFSET')
477: AND enabled_flag = 'Y'
478: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)