APPS.INV_ITEM_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 2854: AND org_id IN (-99, (SELECT org_information3 FROM hr_organization_information

2850: FROM ZX_OUTPUT_CLASSIFICATIONS_V
2851: WHERE lookup_code = l_item_rec.TAX_CODE
2852: AND enabled_flag = 'Y'
2853: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
2854: AND org_id IN (-99, (SELECT org_information3 FROM hr_organization_information
2855: WHERE ( ORG_INFORMATION_CONTEXT || '') ='Accounting Information'
2856: AND ORGANIZATION_ID=l_Item_rec.organization_id))
2857: AND rownum = 1;
2858: EXCEPTION

Line 2878: AND org_id IN (-99, (SELECT org_information3 FROM hr_organization_information

2874: WHERE nvl(tax_type,'X') not in ('AWT','OFFSET') --Modified to fix bug 7588091
2875: AND enabled_flag = 'Y'
2876: AND sysdate between start_date_active and nvl(end_date_active,sysdate)
2877: AND lookup_code = l_Item_rec.PURCHASING_TAX_CODE
2878: AND org_id IN (-99, (SELECT org_information3 FROM hr_organization_information
2879: WHERE ( ORG_INFORMATION_CONTEXT || '') ='Accounting Information'
2880: AND ORGANIZATION_ID=l_Item_rec.organization_id))
2881: AND rownum = 1;
2882: EXCEPTION