APPS.EGO_ITEM_ORG_ASSIGN_PVT dependencies on ZX_OUTPUT_CLASSIFICATIONS_V

Line 241: FROM ZX_OUTPUT_CLASSIFICATIONS_V

237: /* Bug 5207014 - Validating Output Tax Classification Code */
238: IF ( p_tax_code IS NOT NULL AND G_TAX_CODE_CONTROL_LEVEL = 1 ) THEN
239: BEGIN
240: SELECT 1 INTO l_exists
241: FROM ZX_OUTPUT_CLASSIFICATIONS_V
242: WHERE lookup_code = p_tax_code
243: AND enabled_flag = 'Y'
244: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
245: AND org_id IN (p_organization_id,-99)

Line 437: FROM ZX_OUTPUT_CLASSIFICATIONS_V

433: --Bug 5622813 NULL out tax codes if INVALID for current org and the control level is ORG
434: BEGIN
435: IF l_item_rec.tax_code IS NOT NULL THEN
436: SELECT 1 INTO l_exists
437: FROM ZX_OUTPUT_CLASSIFICATIONS_V
438: WHERE lookup_code = l_item_rec.tax_code
439: AND enabled_flag = 'Y'
440: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
441: AND org_id IN (l_item_rec.organization_id,-99)