DBA Data[Home] [Help]

APPS.INV_ITEM_PVT dependencies on HR_ORGANIZATION_INFORMATION

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

2589: FROM ZX_OUTPUT_CLASSIFICATIONS_V
2590: WHERE lookup_code = l_item_rec.TAX_CODE
2591: AND enabled_flag = 'Y'
2592: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
2593: AND org_id IN (-99, (SELECT org_information3 FROM hr_organization_information
2594: WHERE ( ORG_INFORMATION_CONTEXT || '') ='Accounting Information'
2595: AND ORGANIZATION_ID=l_Item_rec.organization_id))
2596: AND rownum = 1;
2597: EXCEPTION

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

2613: WHERE tax_type not in ('AWT','OFFSET')
2614: AND enabled_flag = 'Y'
2615: AND sysdate between start_date_active and nvl(end_date_active,sysdate)
2616: AND lookup_code = l_Item_rec.PURCHASING_TAX_CODE
2617: AND org_id IN (-99, (SELECT org_information3 FROM hr_organization_information
2618: WHERE ( ORG_INFORMATION_CONTEXT || '') ='Accounting Information'
2619: AND ORGANIZATION_ID=l_Item_rec.organization_id))
2620: AND rownum = 1;
2621: EXCEPTION