DBA Data[Home] [Help]

APPS.OM_TAX_UTIL dependencies on HR_ALL_ORGANIZATION_UNITS

Line 511: FROM hr_all_organization_units hu

507: THEN
508: BEGIN
509: SELECT location_id
510: INTO l_ship_from_location_id
511: FROM hr_all_organization_units hu
512: WHERE hu.organization_id = l_ship_from_org_id;
513: EXCEPTION
514: WHEN OTHERS THEN
515: NULL;

Line 582: from HR_ALL_ORGANIZATION_UNITS

578: --bug7228640
579: begin
580: select location_id
581: into l_bill_from_location_id
582: from HR_ALL_ORGANIZATION_UNITS
583: where organization_id = p_header_rec.org_id ;
584: Exception
585: when others then
586: l_bill_from_location_id := NULL;