DBA Data[Home] [Help]

APPS.INV_LABEL_PVT8 dependencies on HR_ORGANIZATION_UNITS

Line 813: FROM hr_organization_units hou

809: CURSOR c_org_name(p_organization_id NUMBER) IS
810: SELECT hou.name organization_name
811: , loc.telephone_number_1 org_tel_num
812: , loc.telephone_number_2 org_fax_num
813: FROM hr_organization_units hou
814: , hr_locations_all_v loc
815: WHERE hou.organization_id = p_organization_id
816: AND hou.location_id = loc.location_id (+);
817: