DBA Data[Home] [Help]

APPS.OM_TAX_UTIL dependencies on HR_ALL_ORGANIZATION_UNITS

Line 536: FROM hr_all_organization_units hu

532: IF (l_ship_from_org_id IS NOT NULL AND l_ship_from_org_id <> FND_API.G_MISS_NUM) THEN
533: BEGIN
534: SELECT location_id
535: INTO l_ship_from_location_id
536: FROM hr_all_organization_units hu
537: WHERE hu.organization_id = l_ship_from_org_id;
538: EXCEPTION
539: WHEN OTHERS THEN
540: NULL;

Line 592: FROM HR_ALL_ORGANIZATION_UNITS

588: END IF;
589: BEGIN
590: SELECT location_id
591: INTO l_bill_from_location_id
592: FROM HR_ALL_ORGANIZATION_UNITS
593: WHERE organization_id = l_header_rec.org_id ;
594: EXCEPTION
595: WHEN OTHERS THEN
596: l_bill_from_location_id := NULL;