DBA Data[Home] [Help]

APPS.OE_BULK_TAX_UTIL dependencies on HR_ALL_ORGANIZATION_UNITS

Line 608: from HR_ALL_ORGANIZATION_UNITS

604:
605: begin
606: select location_id
607: into l_bill_from_location_id
608: from HR_ALL_ORGANIZATION_UNITS
609: where organization_id = OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index);
610: Exception
611: when others then
612: l_bill_from_location_id := NULL;

Line 790: FROM hr_all_organization_units hu

786: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(l_index) IS NOT NULL THEN
787: BEGIN
788: SELECT location_id
789: INTO l_ship_from_location_id
790: FROM hr_all_organization_units hu
791: WHERE hu.organization_id = OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(l_index);
792: EXCEPTION
793: WHEN OTHERS THEN
794: NULL;